118 reputation
5
bio website
location Vila Velha, Brazil
age 38
visits member for 2 years, 3 months
seen Aug 18 at 15:54

C2 Tecnologia


Aug
4
comment Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Thank you Erwin! I didn't know I need to run "analyze" after create an index on temp tables (I just don't get why this isn't done by it self behind the scenes... but this a subject for another post!)
Aug
4
awarded  Scholar
Aug
4
awarded  Supporter
Aug
4
accepted Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Aug
4
awarded  Editor
Aug
4
revised Efficient way to insert/update/delete table records from complex query in Postgres 9.x
more information
Aug
4
comment Efficient way to insert/update/delete table records from complex query in Postgres 9.x
@ErwinBrandstetter: I have used truncate, but it "locks" the records and I can't do that. You said: " as long as you have enough temp buffers and the table can reside in RAM". Is there any way to tell if table "fits" in RAM?
Aug
3
comment Efficient way to insert/update/delete table records from complex query in Postgres 9.x
They insert records into another tables if record's content changes.
Aug
3
asked Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Mar
4
awarded  Popular Question
Oct
9
comment Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf
Yes, I did remove hash # from the start of the line, and I've edit the right postgresql.conf (as show in 'show config_file;'), but with no success.
Sep
22
awarded  Student
Sep
20
asked Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf