network profile
| bio | website | filip.rembialkowski.net |
|---|---|---|
| location | Warsaw, Poland | |
| age | 37 | |
| visits | member for | 1 year, 7 months |
| seen | Apr 4 at 13:00 | |
| stats | profile views | 22 |
A guy who loves fiddling with databases (especially PostgreSQL) and does it for a living. Strong GNU/Linux background, studied math for a while.
|
Mar 8 |
revised |
How many queries per second is my Postgres executing? improve answer |
|
Mar 8 |
revised |
How many queries per second is my Postgres executing? improve answer |
|
Mar 8 |
revised |
How many queries per second is my Postgres executing? improve answer |
|
Mar 7 |
answered | How many queries per second is my Postgres executing? |
|
Mar 3 |
comment |
“custom archiver out of memory” error when restoring large DB using pg_restore This error says "463110542nd line after COPY video_data ... statement inside the dump is broken". You can try to convert the dump to a text file with pg_restore --clean --no-acl --no-owner -v db.dump -f db.txt. BTW - did you notice this big number is exactly 16 exabytes? This might be related to a bug in operating system / libs (google for similar bug reports). |
|
Mar 3 |
awarded | Organizer |
|
Mar 3 |
revised |
“custom archiver out of memory” error when restoring large DB using pg_restore edited tags |
|
Mar 1 |
comment |
“custom archiver out of memory” error when restoring large DB using pg_restore "extra data after..." - this means malformed line in the dump. is it really your data? can you locate this offending row in the source database? |
|
Feb 1 |
revised |
Good, Bad or Indifferent: WHERE 1=1 improve answer |
|
Feb 1 |
comment |
Pgpool, Postgresql and Apache tuning (1000 concurrent spatial queries) why "that pgPool is a configured as a load balancer suggests that this is all read-only"? |
|
Feb 1 |
answered | Good, Bad or Indifferent: WHERE 1=1 |
|
Oct 3 |
awarded | Yearling |
|
Sep 4 |
revised |
Rotate a table in PostgreSQL answered |
|
Sep 4 |
comment |
Rotate a table in PostgreSQL thanks! simple and unexpected :-) |
|
Sep 4 |
accepted | Rotate a table in PostgreSQL |
|
Apr 25 |
comment |
Rotate a table in PostgreSQL People, I have improved the question, so I would be thankful if you review it once more and could you please remove the mod-downs. Thanks! |
|
Apr 25 |
revised |
Rotate a table in PostgreSQL improve question |
|
Apr 24 |
comment |
Rotate a table in PostgreSQL a_horse, two reasons (1) TRUNCATE is not mvcc safe, (2) it's a "legacy app", ie. expensive to change |
|
Apr 24 |
comment |
Rotate a table in PostgreSQL xeno, I heard that content duplication is a Bad Thing (tm) ;-) |
|
Apr 23 |
asked | Rotate a table in PostgreSQL |
