3,695 reputation
419
bio website manitou-mail.org/about-dv.php
location Paris, France
age
visits member for 2 years, 4 months
seen 4 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.


Jul
3
comment Selecting 3MB (or more/less) data from database server
What a strange question... select repeat('A',3000000) will give you 3 million bytes to fetch, if that's what you're after.
Jul
3
comment How many Maximum Number of database can be created in single instance of PostgreSQL?
Personally, I don't see what's unclear in this question, but anyway it appears to be a duplicate of: Maximum number of databases for single instance of PostgreSQL 9
Jun
26
comment Can I add a primary key automatically for all tables?
If a table doesn't have a PK, a person understanding the design should make a conscious decision about adding one or not. An artificial ID that would never going be used by any query is worthless and worse than that, a useless drag on write performance and a threat to previously-working code.
Jun
25
comment changed password for postgres login in pgAdmin, now can't connect to server
@jcollum: can you show the result of pg_lsclusters ?
Jun
25
answered changed password for postgres login in pgAdmin, now can't connect to server
Jun
25
comment Slow search times with functions despite index?
Given a have a few billion records with roughly 150 million a day: consider partitioning by day or even smaller time segments.
Jun
23
comment Issue working with Postgres on Windows
@a_horse_with_no_name: the asker doesn't get the option to use -f because the psql command line invocation is generated by pgadmin.
Jun
23
comment Issue working with Postgres on Windows
@George: your dump is apparently for MySQL, not PostgreSQL. It encloses table names between backticks like only MySQL does.
Jun
22
comment Problems while building plpgsql_check on Windows
It looks like you'd have to build it yourself from the source code.
Jun
20
comment Problems while building plpgsql_check on Windows
I don't know about the last part of the question, but anyway you don't link with a .DLL at build time, that's the root cause of the error. You want the corresponding .LIB instead. See for example stackoverflow.com/questions/24222423 but knowing that plpgsql.lib does not ship with entreprisedb pre-compiled binaries.
Jun
20
answered Issue working with Postgres on Windows
Jun
12
comment Postgres: my “data/backup” directory is way too large
@Reza: not necessarily, you may use streaming replication, without file-based log-shipping and archive_mode off on the master
Jun
12
answered Postgres: my “data/backup” directory is way too large
Jun
10
answered PgBouncer Uncertainties
Jun
9
answered trigger_file doesn't work
Jun
8
answered Column vs Field: have I been using these terms incorrectly?
Jun
8
comment trigger_file doesn't work
That would indicate the recovery.conf you're looking at is ignored by postgres. At least that's consistent with its trigger_file being ignored too.
Jun
3
answered Table variable not Recognized in stored procedure
May
31
answered Is there a configuration setting for how many pages ANALYZE will scan?
May
28
comment How do I decompose ctid into page and row numbers?
2^40 is only 1TB, not 32TB which is 2^45, which divided by 2^13 gives 2^32, hence the full 32 bits being necessary for the page number.