7 apr 2007 kl. 21.07 skrev RPK:
I am using PGSQL 8.2.3 on Windows XP. I want to know whether there
is any way
of documenting the schema of PGSQL database so that I can get a
printed copy
of the same.
Some years ago (2003) I did that, and published it at www.linuxbog.dk/dokumentation/do
You'll need to create a custom function in Postgres to support this,
which is fairly easy. It's been done before- do a search on Google:
http://www.hclausen.net/psql.php
On 5 Apr 2007 01:27:15 -0700, marcel.beutner <[EMAIL PROTECTED]> wrote:
Hello,
Thanks a lot for your answers! But I don't n
I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way
of documenting the schema of PGSQL database so that I can get a printed copy
of the same.
--
View this message in context:
http://www.nabble.com/Documenting-PGSQL-database.-tf3541712.html#a9886934
Sent from the Postgre
On Sat, Apr 07, 2007 at 01:49:38PM +0200, Marcus Engene wrote:
> Michael Fuhr skrev:
> >How often does this table receive updates and deletes and how often
> >are you vacuuming it?
>
> If I should take a guess, there are 5 deletes per day and 5 updates or
> inserts per hour. The table is 1.5 year
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of John D. Burger
>Sent: zaterdag 7 april 2007 2:04
>To: Postgres General
>Subject: [GENERAL] New to concurrency
>
>For the first time, I find myself wanting to use some of PG's
>concurrency control stuff, a
Michael Fuhr skrev:
On Sat, Apr 07, 2007 at 09:28:58AM +0200, Marcus Engene wrote:
INFO: "apa_item_common": removed 9028 row versions in 3651 pages
DETAIL: CPU 0.24s/0.36u sec elapsed 30.69 sec.
INFO: "apa_item_common": found 9028 removable, 12863 nonremovable row
versions in 14489 pages
On Fri, Apr 06, 2007 at 08:03:42PM -0400, John D. Burger wrote:
> For the first time, I find myself wanting to use some of PG's
> concurrency control stuff, and I could use some advice.
>
> I have requests showing up in a database, and I have one or more
> servers picking these up with listen/
On Sat, Apr 07, 2007 at 09:28:58AM +0200, Marcus Engene wrote:
> INFO: "apa_item_common": removed 9028 row versions in 3651 pages
> DETAIL: CPU 0.24s/0.36u sec elapsed 30.69 sec.
> INFO: "apa_item_common": found 9028 removable, 12863 nonremovable row
> versions in 14489 pages
> DETAIL: 0 dead
Tom Lane skrev:
Marcus Engene <[EMAIL PROTECTED]> writes:
-> Index Scan using apa_item_common_x1 on apa_item_common aic
(cost=0.00..4956.68 rows=1174 width=8) (actual time=19.854..9557.606
rows=1226 loops=1)
If the table only has 12000 rows then it should never have used an
