Christian B. Almeida
Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 8
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
May
25
awarded  Notable Question
Mar
2
awarded  Tumbleweed
Feb
11
awarded  Popular Question
Sep
24
awarded  Autobiographer
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
Sep
22
awarded  Student
Sep
20
asked Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf