meta user
network profile
| bio | website | blog.teksol.info |
|---|---|---|
| location | Sherbrooke, Canada | |
| age | 40 | |
| visits | member for | 1 year, 7 months |
| seen | Jan 4 at 21:07 | |
| stats | profile views | 16 |
I am a web developer based in Sherbrooke, QC, Canada. I have been doing Rails development since it's 0.13 days, or 2005.
I currently do big data analysis using PostgreSQL for Seevibes.
|
Dec 6 |
comment |
What is the purpose of PGBouncer's parameter server_reset_query? Using check_postgres, it should connect directly to the database cluster, and not through the connection pooler. You should have a separate check for the connection pooler itself, something like check_pgbouncer. |
|
Nov 30 |
comment |
Postgres replication/replication to server outside firewall You might want to take a look at github.com/omniti-labs/omnipitr for archiving. That's what I use, and I'm satisfied. |
|
Nov 30 |
comment |
Removing Archive Logs after PostgreSQL PITR online-recovery For a good solution to correctly distribute archive files, I use OmniPITR, from OmniLabs: github.com/omniti-labs/omnipitr |
|
Sep 10 |
comment |
Maximum number of databases for single instance of PostgreSQL 9 This is a very good and valid point. Maybe the OP should think about using schemas, and only have a few tables in the public schema, available for JOINing with tables in the private customer's schema. |
|
Aug 24 |
comment |
Pros and Cons of virtualisation technology for database-server and datastorage I'm hosting PostgreSQL on a cloud server platform (nothing under my control) and we get terrible performance: IO wait % between 5 and 75%, depending on the phase of the moon, and whether or not Bill Gates had butter on his toast this morning. Terrible performance. We're migrating to hardware ASAP. |
|
Aug 24 |
comment |
Copy PostgreSQL data from one PC to another Better answer as this mentions use of UTF8 which will help down the line. |
|
Jun 2 |
comment |
Are regular VACUUM ANALYZE stil recommended under 9.1? Thanks for the pointer to n_dead_tup and friends. I do have rollup tables on which I frequently (hourly) destroy and recreate thousands of rows. I'll check the values and schedule appropriately. The answer is always "monitor, think, act" anyway :) |
|
Mar 1 |
comment |
Joining based on date (or date range) Using the lead window function, you could generate the effective_to date. See postgresql.org/docs/9.1/static/… |
|
Feb 29 |
comment |
PostgreSQL partitioning query performance inexplicably bad I've been wondering the same thing. |
|
Feb 23 |
comment |
Does running pg_dump on live db produce consistent backups? I literally LOL'd when I read "you can trust your data in PostgreSQL" :) |
|
Feb 21 |
comment |
Most idiomatic way to implement UPSERT in Postgresql nowadays What's the advantage of a writable CTE vs a function? |
|
Feb 10 |
comment |
Ways to speed up IN queries under PostgreSQL I'll try the temporary table route. |
|
Feb 10 |
comment |
Ways to speed up IN queries under PostgreSQL The IDs are returned from Twitter as the list of followers a person has. |
|
Feb 10 |
comment |
How to specify trigger execution order under PostgreSQL? Good old RTFM... But reading the statement, if the insert trigger is last, then other triggers can fire and complete. I'll investigate this further. Thanks! |
|
Feb 9 |
comment |
How to specify trigger execution order under PostgreSQL? Simple copy paste error. Wrote the SQL above for illustrative purposes. Thanks for the answer! |
|
Jan 20 |
comment |
How to calculate cache misses for PostgreSQL How large is the database? Does the database fit in memory? Are you checking vmstat / iostat on a cold boot? Remember that the database has to be loaded in memory before caching can be effective. |
|
Jan 6 |
comment |
Configuring PostgreSQL for write performance +1 for synchronous_commit = off |
|
Jan 4 |
comment |
Storing bitsets in PostgreSQL? Good thought. Haven't had a chance to try it yet, but it might be the way to go for me. Thanks! |
|
Dec 5 |
comment |
Storing bitsets in PostgreSQL? True enough, but on my dev machine of 4 GiB and 2 CPUs, that's causing me considerable grief. Having more RAM will help, obviously. |
|
Nov 8 |
comment |
Gaining visibility into long running INSERT INTO … SELECT Oh, good idea. Thanks! |
