4,070 reputation
420
bio website manitou-mail.org/about-dv.php
location Paris, France
age
visits member for 2 years, 6 months
seen 9 hours ago

Let's try to share the bits of knowledge gained during those innumerable hours of programming... Nowadays I use mostly PostgreSQL, C++/Qt, Perl, php on Unix servers.


Sep
15
comment Temporary schema per connection?
@Gili: Note that this technique of never committing CREATE SCHEMA is the only one that can guarantee to have them disappear when the unit test gets killed.
Sep
6
answered SQL order by query results in any arbitrary (but reproducible) manner
Aug
30
comment How do I maintain high INSERT-performance on PostgreSQL
"full vacuum" is ambiguous. It may mean VACUUM FULL on a specific table or simple-VACUUM on the whole database or VACUUM FULL on the whole database. Anyway the fact that it helps with performance is suspicious. VACUUM reclaims dead rows resulting from UPDATEs and DELETEs, it's not needed in an INSERT-only scenario.
Aug
27
answered postgresql cannot drop a table when autovacuum holds lock on it
Aug
27
comment Storing DB credentials in an application source code?
The point of the login_table is generally when you can't create the accounts as database users, for all sorts of reasons. But if you plan to issue SET ROLE with the login, it has to exist as a db role, so what's the point of not using it to connect in the first place and let postgres deal with the authentication?
Aug
26
answered Constrain a postgres timestamp to “End of day”?
Aug
21
comment How to optimise window queries in postgres
Also that shouldn't cause slowness, but you don't have to PARTITION BY competition_id since there's only one value (due to the WHERE clause).
Aug
21
comment How to optimise window queries in postgres
You have 175k rows total but the planner thinks you have 250k rows just for competition_id = 'bdd94eee-25a4-481f-b7b5-37aaed953c6b'. Use EXPLAIN ANALYZE to get actual counts. The selectivity of this particular ID is key here.
Aug
14
comment Busy table is not getting vacuumed
That's a lot of dead tuples! If possible, consider partitioning the table by timestamp and dropping the old partitions instead of deleting. The major caveat being that unique index across partitions are not supported.
Aug
14
comment Busy table is not getting vacuumed
See Aggressive Autovacuum on PostgreSQL. Also it would be interesting to have select * from pg_stat_user_tables for this table (use \x in psql for a nicely formatted output)
Aug
12
answered PosgreSQL: very slow select on a single table with no joins
Aug
11
comment Why does the behavior of array syntax differ from '(?,?)' syntax when updating a point field and that field is NULL?
It might be a bug. At least it looks like an inconsistency that's worth to be reported as such. The doc says we can subscript point with the array-like syntax, but in a super-concise way with no mention of updates or special cases for nulls.
Aug
8
awarded  Excavator
Aug
8
comment How do I list all databases and tables using psql in a pipable format?
Agreed, I've changed the title for something more descriptive. But anyway the -Atc switches should be mentioned in the answers of the much more popular question you linked.
Aug
8
revised psql, getting a list of databases to be parsed by a script
Set a more descriptive title
Aug
2
answered PostgreSQL equivalent of mysqld --bootstrap or mysqld --init-file
Jul
28
answered Missing the pg_ctl package in Postgres 9.3 installation
Jul
18
answered PostgreSQL/ Linux, way to have DNS forward to a port/cluster?
Jul
17
comment Primary key with randomly varying increments (so it cannot be guessed easily)
What's the maximum acceptable size or format for the ID? The possible solutions depend mainly on that.
Jul
13
comment How to configure phpgdadmin?
Your web server lists the files instead of loading index.php. That's a php or web server config problem.