Re: [ADMIN] Performance issue

2005-02-05 Thread Pascal Van Puymbroeck
OK, I found the thread you mentioned and installed the Qos Service on my win2K netwerk, but it gave no effect. So it must be something else in this case. Pascal Van Puymbroeck ZENON productions bvba ---(end of broadcast)--- TIP 7: don't forget to

Re: [ADMIN] Performance issue

2005-02-05 Thread Tom Lane
Pascal Van Puymbroeck <[EMAIL PROTECTED]> writes: > I would like to solve a strange behaviour I encountered using Postgresql > 8.0.1 on windows. Connecting to the database is OK, but when running a > query to the database, its terribly slow. The fact is that I need the > database to be running

[ADMIN] Performance issue

2005-02-05 Thread Pascal Van Puymbroeck
Hi folks, I would like to solve a strange behaviour I encountered using Postgresql 8.0.1 on windows. Connecting to the database is OK, but when running a query to the database, its terribly slow. The fact is that I need the database to be running on the same machine, my application is. So I

Re: [ADMIN] performance issue using DBI

2002-06-06 Thread nikolaus
Nicolas, The more data your tables contain the more work PostgreSQL needs to do. Adding indexes on your tables makes the INSERTS slower due to additional overhead. Indexes speed up SELECT but slow down INSERT. Therefore OLTP systems tend to have few indexes and data warehouses many. Instead o

[ADMIN] performance issue using DBI

2002-06-06 Thread Nicolas Nolst
Hi all,I have developped a perl script to populate a database with two tables: sessionsand actions.the table actions contains the following columns: session_id, url, timestamp.The column session_id references to the table sessions.the table sessions contains the following columns: session_id, remo

[ADMIN] Performance issue

1999-05-26 Thread Steven M. Wheeler
Configuration: Compaq DeskPro, 450MHz Pentium II, 256MB RAM, hda: WDC AC31R, 9541MB w/512kB Cache, CHS=20678/15/63, UDMA hdc: Maxtor 90680D4, 6485MB w/256kB Cache, CHS=13176/16/63, UDMA Slackware 3.6 installation, Linux kernel 2.0.36 PostgreSQL 6.4.2 I am in process of doi