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
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
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
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
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
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
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
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
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-
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
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
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
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
14 matches
Mail list logo
