Greetings,
I am sure I have seen this, but I have searched the docs, and
tried to search the archives, which was a definite exercise in futility.
How can I list the triggers on a specific table? I tried the following:
=> select * from pg_trigger where tgargs like '%foo%' ;
ERROR: Unabl
Hi,
> > > > > We have a fresh database and have begun to observe performance
> > > > > degradation for INSERTs as a table went from empty to
> > > > > 100,000-ish rows. Initial INSERTs were sub second while after
> > > > > 30k rows, they were 1-3 seconds.
> > > >
> > > > we just hit this problem
I never used it, but maybe you could test it:
http://www.thekompany.com/projects/kugar/
Raph
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
We have 7.1.3 PostgreSQL running on a NetVista PIII 800 with 512 MB ram 'n 2
80 GB IDE 10krmp Seagate disks, using a linked script for boot in
/etc/rc.d/rc2.d with "hdparm -X66 -u1 -d1 -m16 -c3"
We cannot use "copy" because of "strange char..."
So...we make at week (WITH 8K ROWS), from a güinbox
Brian McCane <[EMAIL PROTECTED]> writes:
> How can I list the triggers on a specific table?
select * from pg_trigger where tgrelid =
(select oid from pg_class where relname = 'foo');
This table is documented now in the 7.2 documentation; see
http://developer.postgresql.org/docs/postgres/catalog-
Brian McCane wrote:
> How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
SELECT t.oid, t.*
FROM pg_trigger t, pg_clas
At 11:01 AM 1/29/02 +0800, Lau NH wrote:
Hi all,
I am writing a php script to backup my postgres database
through web interface, but my database is password required. When I
do a pg_dump at the linux shell prompt, it will prompt for password in
order to backup the database, does anyone know ho
Hi,
anybody has an experience how is stable postgresql under Windows system ?
I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed
by very bad performance. Are there something I could tune ?
I got 250 sel/sec on simple select from table with 500 rows !
Under Linux I have 2500 sel/s
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> anybody has an experience how is stable postgresql under Windows system ?
> I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed
> by very bad performance. Are there something I could tune ?
> I got 250 sel/sec on simple select from table
On Wed, 30 Jan 2002, Arguile wrote:
> Brian McCane wrote:
> > How can I list the triggers on a specific table?
>
> Just as I was typing this I noticed Tom already replied. Just incase you
> want to know all triggers referencing the table in addition to those on it
> (eg. foreign key constraints).
> > How were you inserting the data? Were you doing multiple inserts per
> > transactions? Copy? That sounds really slow to me.
>
> The database mainly contains integers, which represent the behavior of
> internet users on our site, so it's very compact data.
> We used multiple insert with my
On Wed, 30 Jan 2002, Brian McCane wrote:
> On Wed, 30 Jan 2002, Arguile wrote:
>
> > Brian McCane wrote:
> > > How can I list the triggers on a specific table?
> >
> > Just as I was typing this I noticed Tom already replied. Just incase you
> > want to know all triggers referencing the table in a
Brian McCane <[EMAIL PROTECTED]> writes:
> Thanks Tom and Arguile that definitely helps. Now for my more
> pressing, but forgotten question. Shouldn't PostgreSQL have automatically
> dropped that trigger when I dropped the table?
It should, and it does.
IIRC, there's a bug in some versio
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> anybody has an experience how is stable postgresql
under Windows
system ?
> I tried postgresq 7.1 under Cygwin, Windows 98 and
was dissapointed
> by very bad performance.
As you might guess, Cygwin's speed depends heavily on
the version of Windows yo
14 matches
Mail list logo
