meta user
network profile
| bio | website | petereisentraut.blogspot.com |
|---|---|---|
| location | Pennsylvania | |
| age | 34 | |
| visits | member for | 2 years, 4 months |
| seen | 16 hours ago | |
| stats | profile views | 137 |
PostgreSQL and Debian hacker, DBA at MeetMe
|
Apr 28 |
comment |
Is there better way to 'touch' a row than performing a dummy update? That certainly sounds more sane. |
|
Mar 4 |
comment |
PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly Yes, if you replicate to an OS with a different locale implementation, things will break badly. |
|
Jan 2 |
comment |
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu) That creates a table diagram. Getting from there to an entity-relationship diagram is another step. |
|
Dec 12 |
comment |
Postgresql could not find pg_xlog Could you show the output of ls -l $PGDATA and the exact messages from the server log? |
|
Dec 6 |
comment |
What is the purpose of PGBouncer's parameter server_reset_query? @FrançoisBeausoleil: I disagree. I want to check the connection as the client sees it, and the fact that it's pgbouncer should be transparent to the monitoring software. |
|
Feb 15 |
comment |
pg_restore fails for a pg_dump from a db that worked just fine But varchar(200) means 200 characters, not 200 bytes. |
|
Nov 9 |
comment |
PgAdmin III - How to connect to database when password is empty? I don't know for sure, but it's easy to imagine that PgAdmin doesn't support that. |
|
Oct 28 |
comment |
storing a mirror of IMAP/pop3 folder/inbox in a local DB, what choices are there? Hence the suggestion to use IMAP synching. |
|
Oct 27 |
comment |
Unicode support of PostgreSQL and its performance Have you read the documentation? postgresql.org/docs/current/static/multibyte.html |
|
Aug 18 |
comment |
PostgreSQL: Corrupt primary key, inconsistent table You might want to look at the plan of the grouping query to check that it doesn't use the index. |
|
Aug 1 |
comment |
Index Generation in Postgres The algorithms for sorting on disk and in memory are not the same, so they will use different amounts of memory. But it's actually more likely that the in-memory sort uses more memory. Still, the numbers that have been quoted are quite bizarre, so it's worth a try. |
|
Jul 30 |
comment |
Index Generation in Postgres This doesn't apply to his case, because he is using pg_dump, which already creates the indexes after loading the data. It says so in the question. |
|
Jul 2 |
comment |
Postgresql row-level encryption Not that it would make a difference in this case, but you are linking to the PostgreSQL 8.0 documentation, which is more than 6 years old. |
|
Jun 27 |
comment |
PostgreSQL: Disk space not released after TRUNCATE It's conceivable that another backend process still has a file descriptor to the file open. If this happens again, I'd try terminating all other backend processes, just to see whether it makes a difference. |
|
Apr 17 |
comment |
Where does the magic column “name” come from? It would help to show the definition of site. |
|
Mar 2 |
comment |
How to upgrade PostgreSQL minor releases without a dump/restore? I didn't downvote anything. |
|
Mar 1 |
comment |
How to upgrade PostgreSQL minor releases without a dump/restore? Which part of "stop the database server, install the updated binaries, and restart the server" are you having problems with? |
|
Feb 20 |
comment |
How do I find PostgreSQL's data directory? This is specific to Debian/Ubuntu. |
|
Feb 7 |
comment |
Why are so many MPP solutions based on PostgreSQL instead of MySQL? Gaius: What's your point? The MPP solutions discussed here sell proprietary software that is derived from open-source software. They don't sell their software as a service. |
|
Feb 7 |
comment |
Why are so many MPP solutions based on PostgreSQL instead of MySQL? Well, most of the time, these commercial forks develop their own planner and optimizer to accommodate the distributed or parallel nature of what they are doing. |
