FAQ

PostgreSQL > pgsql-performance > December 2005

Search Discussions

84 discussions - 657 posts

  • I'll just start by warning that I'm new-ish to postgresql. I'm running 8.1 installed from source on a Debian Sarge server. I have a simple query that I believe I've placed the indexes correctly for, ...
    Kevin BrownKevin Brown
    Dec 14, 2005 at 10:09 pm
    Dec 21, 2005 at 6:55 am
  • Hi! What do you suggest for the next problem? We have complex databases with some 100million rows (2-3million new records per month). Our current servers are working on low resposibility in these ...
    Antal AttilaAntal Attila
    Dec 20, 2005 at 6:26 pm
    Jan 5, 2006 at 4:44 pm
  • Hello all, It seems that I'm starting to outgrow our current Postgres setup. We've been running a handful of machines as standalone db servers. This is all in a colocation environment, so everything ...
    Charles SprickmanCharles Sprickman
    Dec 14, 2005 at 6:50 am
    Jan 18, 2006 at 6:54 pm
  • Our application tries to insert data into the database as fast as it can. Currently the work is being split into a number of 1MB copy operations. When we restore the postmaster process tries to use ...
    Steve OuallineSteve Oualline
    Dec 2, 2005 at 3:01 am
    Dec 4, 2005 at 1:21 am
  • Paal, Postgres currently lacks a bitmap index, though 8.1 has a bitmap "predicate merge" in 8.1 We have recently completed an Oracle-like bitmap index that we will contribute shortly to Postgres and ...
    Luke LonerganLuke Lonergan
    Dec 11, 2005 at 9:15 pm
    Dec 18, 2005 at 10:28 pm
  • Hi - Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc T1 processor and architecture on Solaris 10? I have a custom built retail sales reporting that I developed using ...
    Juan CaseroJuan Casero
    Dec 18, 2005 at 4:30 pm
    Dec 20, 2005 at 7:34 pm
  • I ran a bit exhaustive pgbench on 2 test machines I have (quad dual core Intel and Opteron). Ofcourse the Opteron was much faster, but interestingly, it was experiencing 3x more context switches than ...
    Anjan DaveAnjan Dave
    Dec 6, 2005 at 7:04 pm
    Dec 20, 2005 at 7:50 pm
  • I have a choice to make on a RAID enclosure: 14x 36GB 15kRPM ultra 320 SCSI drives OR 12x 72GB 10kRPM ultra 320 SCSI drives both would be configured into RAID 10 over two SCSI channels using a ...
    Vivek KheraVivek Khera
    Dec 8, 2005 at 4:52 pm
    Dec 12, 2005 at 11:17 pm
  • Hi, I would like to use autovacuum but is not too much expensive collecting row level statistics? Are there some numbers that I could use? Thanks in advance! Benkendorf ...
    Carlos BenkendorfCarlos Benkendorf
    Dec 11, 2005 at 11:53 am
    Dec 17, 2005 at 2:44 am
  • Hi, Is it possible to get this query run faster than it does now, by adding indexes, changing the query? SELECT customers.objectid FROM prototype.customers, prototype.addresses WHERE ...
    Joost KraaijeveldJoost Kraaijeveld
    Dec 6, 2005 at 9:43 am
    Dec 6, 2005 at 8:46 pm
  • Hello, We have a database containing PostGIS MAP data, it is accessed mainly via JDBC. There are multiple simultaneous read-only connections taken from the JBoss connection pooling, and there usually ...
    Markus SchaberMarkus Schaber
    Dec 20, 2005 at 10:41 am
    Dec 20, 2005 at 4:17 pm
  • Hi! I've got an urgent problem with an application which is evaluating a monthly survey; it's running quite a lot of queries like this: select SOURCE.NAME as TYPE, count(PARTICIPANT.SESSION_ID) as ...
    Markus WollnyMarkus Wollny
    Dec 1, 2005 at 3:49 pm
    Dec 10, 2005 at 5:14 pm
  • This didn't get through the first time around, so resending it again. Sorry for any duplicate entries. Hello, I have a question on postgres's performance tuning, in particular, the vacuum and reindex ...
    Ameet KiniAmeet Kini
    Dec 6, 2005 at 5:44 pm
    Dec 8, 2005 at 5:09 pm
  • Greetings all, I'm going to do a performance comparison with DocMgr and PG81/TSearch2 on one end, and Apache Lucene on the other end. In order to do this, I'm going to create a derivative of the ...
    Joshua KramerJoshua Kramer
    Dec 6, 2005 at 4:48 pm
    Dec 7, 2005 at 8:28 am
  • I installed another drive in my linux pc in an attempt to improve performance on a large COPY to a table with a geometry index. Based on previous discussion, it seems there are three things competing ...
    Rick SchumeyerRick Schumeyer
    Dec 2, 2005 at 7:00 pm
    Dec 6, 2005 at 10:00 pm
  • Hi, thanks for your comments so far - I appreciate it. I'd like to narrow down my problem a bit: As I said in the other thread, I estimate that only 20% of the 15,000 tables are accessed regularly. ...
    Michael RiessMichael Riess
    Dec 2, 2005 at 11:02 pm
    Dec 6, 2005 at 3:07 am
  • Hi, We have more than 200 customers running 8.0.3 and two weeks ago started migration project to 8.1.1.After the first migration to 8.1.1 we had to return back to 8.0.3 because some applications were ...
    Carlos BenkendorfCarlos Benkendorf
    Dec 23, 2005 at 12:34 pm
    Dec 24, 2005 at 1:48 am
  • Hi, I'm using PostgreSQL 8.0.3 on Linux RedHat WS 3.0. My application updates counters in DB. I left a test over the night that increased counter of specific record. After night running (several ...
    Assaf YaariAssaf Yaari
    Dec 5, 2005 at 8:17 pm
    Dec 8, 2005 at 2:29 pm
  • I have a case where an outer join's taking 10X more time than a non-outer join; and it looks to me like the outer join could have taken advantage of the same indexes that the non-outer join did. In ...
    Rm_pgRm_pg
    Dec 5, 2005 at 10:11 pm
    Dec 6, 2005 at 9:35 pm
  • src/include/pg_config_manual.h define BLCKSZ 8196 (8kb). Somewhere I readed BLCKSZ must be equal to memory page of operational system. And default BLCKSZ 8kb because first OS where postgres was build ...
    Olleg SamoylovOlleg Samoylov
    Dec 5, 2005 at 1:47 pm
    Dec 6, 2005 at 11:42 am
  • I need to slice up a web server's disk space to provide space for postgres and storing binaries such as images and sound files. I'm thinking of using logical volume management (LVM) to help manage ...
    Rory Campbell-LangeRory Campbell-Lange
    Dec 6, 2005 at 9:39 am
    Dec 8, 2005 at 11:30 am
  • Hi, I have a java.util.List of values (10000) which i wanted to use for a query in the where clause of an simple select statement. iterating over the list and and use an prepared Statement is quite ...
    Bühler, JohannesBühler, Johannes
    Dec 15, 2005 at 12:34 am
    Jan 6, 2006 at 2:04 pm
  • Hi all, Which is the best way to import data to tables? I have to import 90000 rows into a column and doing it as inserts takes ages. Would be faster with copy? is there any other alternative to ...
    ArnauArnau
    Dec 29, 2005 at 9:48 am
    Dec 29, 2005 at 5:05 pm
  • this subject has come up a couple times just today (and it looks like one that keeps popping up). under linux ext2/3 have two known weaknesses (or rather one weakness with two manifestations). ...
    David LangDavid Lang
    Dec 1, 2005 at 3:13 pm
    Dec 20, 2005 at 7:59 pm
  • I have the following table: CREATE TABLE timeblock ( timeblockid int8 NOT NULL, starttime timestamp, endtime timestamp, duration int4, blocktypeid int8, domain_id int8, create_date timestamp, ...
    James KloJames Klo
    Dec 18, 2005 at 5:12 am
    Dec 20, 2005 at 7:16 pm
  • I'm running postgresql 8.1.0 with postgis 1.0.4 on a FC3 system, 3Ghz, 1 GB memory. I am using COPY to fill a table that contains one postgis geometry column. With no geometry index, it takes about ...
    Rick SchumeyerRick Schumeyer
    Dec 1, 2005 at 6:08 pm
    Dec 2, 2005 at 1:04 pm
  • A few WEEKS ago, the autovacuum on my instance of pg 7.4 unilaterally decided to VACUUM a table which has not been updated in over a year and is more than one terabyte on the disk. Because of the ...
    Jeffrey W. BakerJeffrey W. Baker
    Dec 29, 2005 at 10:09 pm
    Jan 5, 2006 at 11:30 am
  • I am currently using a dual Opteron (248) single core system (RAM PC3200) and for a change I am finding that the bottleneck is not disk I/O but CPU/RAM (not sure which). The reason for this is that ...
    Harry JacksonHarry Jackson
    Dec 22, 2005 at 1:20 am
    Dec 30, 2005 at 8:38 am
  • What version of postgres? Copy has been substantially improved in bizgres and also in 8.1. - Luke -------------------------- Sent from my BlackBerry Wireless Device -----Original Message----- From: ...
    Luke LonerganLuke Lonergan
    Dec 22, 2005 at 3:33 am
    Dec 23, 2005 at 4:16 pm
  • Imagine a table named Person with "first_name" and "age". Now let's make it fancy and put a "mother" and "father" field that is a reference to the own table (Person). And to get even fuzzier, let's ...
    Rodrigo MaderaRodrigo Madera
    Dec 3, 2005 at 11:00 pm
    Dec 4, 2005 at 10:19 pm
  • Hello, We used Postgresql 7.1 under Linux and recently we have changed it to Postgresql 8.1 under Windows XP. Our application uses ODBC and when we try to get some information from the server throw a ...
    TeracatTeracat
    Dec 2, 2005 at 4:10 pm
    Dec 2, 2005 at 9:08 pm
  • Hi, We´ve a SELECT that even without ORDER BY is returning the rows in the order that we liked but when we add the ORDER BY clause the runtime and costs are much bigger. We have to use ORDER BY ...
    Carlos BenkendorfCarlos Benkendorf
    Dec 21, 2005 at 6:16 pm
    Dec 22, 2005 at 4:23 pm
  • Hi all, On a user's request, I recently added MySQL support to my backup program which had been written for PostgreSQL exclusively until now. What surprises me is that MySQL is about 20%(ish) faster ...
    Madison KellyMadison Kelly
    Dec 22, 2005 at 2:03 am
    Dec 22, 2005 at 7:08 am
  • Hello, We have the next scenario: Linux box with postgresql 7.2.1-1 (client) Windows XP with postgresql 8.1.1 (server) Windows XP with postgresql 8.1.1 (client) All connected in 10Mb LAN In server ...
    Josep Maria Pinyol FontsecaJosep Maria Pinyol Fontseca
    Dec 21, 2005 at 9:05 am
    Dec 21, 2005 at 6:40 pm
  • Hi all, I have been using PostgreSQL (currently 7.4.7) for several years now and am very happy with it but I currently run a website that has had a little bit of a boost and I am starting to see some ...
    Harry JacksonHarry Jackson
    Dec 15, 2005 at 1:51 am
    Dec 18, 2005 at 2:18 am
  • Forgive the cross-posting, but I found myself wondering if might not be some way future way of telling the planner that a given table (column ?) has a high likelyhood of being TOASTed. Similar to the ...
    Gregory S. WilliamsonGregory S. Williamson
    Dec 15, 2005 at 12:23 am
    Dec 15, 2005 at 2:20 pm
  • Hello, I've got a table with ~60 Million rows and am having performance problems querying it. Disks are setup as 4x10K SCSI 76GB, RAID 1+0. The table is being inserted into multiple times every ...
    Mike CMike C
    Dec 12, 2005 at 2:07 am
    Dec 13, 2005 at 11:54 pm
  • Hi. create table device(id int); insert into device values(1); insert into device values(2); ..... insert into device values(250); create table base ( id int, data float, datatime timestamp, mode ...
    Ключников А.С.Ключников А.С.
    Dec 13, 2005 at 3:18 pm
    Dec 13, 2005 at 10:48 pm
  • Hi all, First of all, please pardon if the question is dumb! Is it even feasible or normal to do such a thing ! This query is needed by a webpage so needs to be lightning fast. Anything beyond 2-3 ...
    Amit V ShahAmit V Shah
    Dec 8, 2005 at 5:24 pm
    Dec 12, 2005 at 10:34 pm
  • Hi, I´m trying to optimize some selects between 2 tables and the best way I found was alter the first table and add the fields of the 2nd table. I adjusted the contents and now a have only one table ...
    Edison AzziEdison Azzi
    Dec 6, 2005 at 8:23 pm
    Dec 11, 2005 at 8:36 pm
  • Question is about the relation between fragmentation of file and VACUUM performance. <Environment OS：RedHat Enterprise Linux AS Release 3(Taroon Update 6) Kernel 2.4.21-37.ELsmp on an i686 Filesystem ...
    Tatsumi AbeTatsumi Abe
    Dec 1, 2005 at 5:58 am
    Dec 1, 2005 at 3:29 pm
  • Hello, we have a PostgreSQL for datawarehousing. As we heard of so many enhancements for 8.0 and 8.1 versions we dicided to upgrade from 7.4 to 8.1. I must say that the COPY FROM processes are much ...
    Albert Cervera ArenyAlbert Cervera Areny
    Dec 27, 2005 at 4:16 pm
    Dec 27, 2005 at 6:56 pm
  • We are trying to ascertain if we are up against the limits of what postgres can accomplish without having the tables clustered. We would prefer not to have to cluster our tables because according to ...
    David ScottDavid Scott
    Dec 26, 2005 at 9:03 pm
    Dec 26, 2005 at 11:52 pm
  • Dear Gurus, Version: 7.4.6 I use a query on a heavily indexed table which picks a wrong index unexpectedly. Since this query is used in response to certain user interactions thousands of times in ...
    Szűcs GáborSzűcs Gábor
    Dec 21, 2005 at 6:02 pm
    Dec 22, 2005 at 12:59 pm
  • I have the following table: CREATE TABLE mytmp ( Adv integer, Pub integer, Web integer, Tiempo timestamp, Num integer, Country varchar(2) ); CREATE INDEX idx_mytmp ON mytmp(adv, pub, web); And with ...
    Cristian PrietoCristian Prieto
    Dec 19, 2005 at 5:33 pm
    Dec 20, 2005 at 9:48 pm
  • Hi, I am not sure if there's an obvious answer to this...If there's a choice of an external RAID10 (Fiber Channel 6 or 8 15Krpm drives) enabled drives, what is more beneficial to store on it, the ...
    Anjan DaveAnjan Dave
    Dec 19, 2005 at 8:04 pm
    Dec 20, 2005 at 7:52 pm
  • Hello group, I've got a really bad problem with my postgres DB and server. It is a linux machine with 1GB of RAM and 2 CPUs. The postgres Version is 7.4. The problem is, that once the postmaster has ...
    Moritz BayerMoritz Bayer
    Dec 16, 2005 at 1:22 pm
    Dec 16, 2005 at 2:33 pm
  • Hi, we have a VIEW that is an UNION of 12 SELECTs, and every member of the UNION have a constant field to be able to distinguish between them. An often performed operation on this VIEW is to search ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Dec 14, 2005 at 8:57 pm
    Dec 14, 2005 at 10:18 pm
  • Hi, I've been working on trying to partition a big table (I've never partitioned a table in any other database till now). Everything went ok, except one query that didn't work afterwards. I've put ...
    Marc CousinMarc Cousin
    Dec 13, 2005 at 11:37 am
    Dec 13, 2005 at 1:11 pm
  • Hi, Is it possible to run a shell script, passing values of fields to it, in a Postgres function ? Yves Vindevogel
    Yves VindevogelYves Vindevogel
    Dec 10, 2005 at 3:53 pm
    Dec 10, 2005 at 4:50 pm
Dec 2005
12
Group Navigation
period‹ prev | Dec 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions84
posts657
users162
websitepostgresql.org
irc#postgresql

162 users for December 2005

Tom Lane: 57 posts David Lang: 35 posts Luke Lonergan: 32 posts Mark Kirkwood: 17 posts Michael Riess: 17 posts Jim C. Nasby: 16 posts Ron: 15 posts Michael Stone: 14 posts Craig A. James: 13 posts Merlin Moncure: 12 posts Michael Fuhr: 12 posts Vivek Khera: 12 posts Carlos Benkendorf: 11 posts Jaime Casanova: 11 posts Simon Riggs: 11 posts Steinar H. Gunderson: 11 posts Bruce Momjian: 10 posts Christopher Kings-Lynne: 10 posts Anjan Dave: 8 posts Juan Casero: 8 posts
show more
Archives