FAQ

Search Discussions

50 discussions - 409 posts

  • Can I ask for some help with benchmarking? There are some results here that show PostgreSQL is slower in some cases than Monet and MySQL. Of course these results were published immediately prior to ...
    Simon RiggsSimon Riggs
    Feb 4, 2008 at 6:36 pm
    Feb 13, 2008 at 8:26 pm
  • I spent a whopping seven hours restoring a database late Fri nite for a client. We stopped the application, ran pg_dump -v -Ft -b -o $db ~/pre_8.3.tar on the 8.2.x db, and then upgrading the software ...
    Douglas J HunleyDouglas J Hunley
    Feb 19, 2008 at 6:05 pm
    Feb 22, 2008 at 10:40 am
  • Hi, I am in the process of setting up a postgresql server with 12 SAS disks. I am considering two options: 1) set up a 12 disks raid 10 array to get maximum raw performance from the system and put ...
    Franck RoutierFranck Routier
    Feb 29, 2008 at 12:26 pm
    Mar 4, 2008 at 3:04 pm
  • Hi all, We're considering setting up a SAN where I work. Is there anyone using a SAN, for postgres or other purposes? If so I have a few questions for you. - Are there any vendors to avoid or ones ...
    Peter KoczanPeter Koczan
    Feb 13, 2008 at 4:57 pm
    Mar 20, 2008 at 3:16 am
  • Hi, I'm noticing a strange increase in the amount of time it takes to issue a NOTIFY statement. I have an existing app that provides a producer / consumer type of queue and that uses the LISTEN / ...
    Joel StevensonJoel Stevenson
    Feb 23, 2008 at 6:51 pm
    Feb 28, 2008 at 2:19 am
  • This might be a weird question...is there any way to disable a particular index without dropping it? There are a few queries I run where I'd like to test out the effects of having (and not having) ...
    Peter KoczanPeter Koczan
    Feb 26, 2008 at 8:46 pm
    Feb 27, 2008 at 11:38 pm
  • I have a table, that in production, currently has a little over 3 million records in production. In development, the same table has about 10 million records (we have cleaned production a few weeks ...
    Sean LeachSean Leach
    Feb 24, 2008 at 3:59 pm
    Feb 25, 2008 at 11:32 pm
  • Hi. I'm trying to optimize the performance of a database whose main purpose is to support two (rather similar) kinds of queries. The first kind, which is expected to be the most common (I estimate it ...
    Kynn JonesKynn Jones
    Feb 22, 2008 at 8:50 pm
    Feb 26, 2008 at 4:49 pm
  • Hi, I'm having some issues with this simple query: SELECT _comment.*, _article.title AS article_title, _article.reference AS article_reference FROM _comment INNER JOIN _article ON _article.id = ...
    Laurent RaufasteLaurent Raufaste
    Feb 26, 2008 at 3:19 pm
    Feb 28, 2008 at 5:46 pm
  • Hi all, The following query takes about 4s to run in a 16GB ram server. Any ideas why it doesn´t use index for the primary keys in the join conditions? select i.inuid, count(*) as total from ...
    Adonias MalossoAdonias Malosso
    Feb 21, 2008 at 8:48 pm
    Feb 22, 2008 at 5:10 am
  • I have serious performance problems with the following type of queries: / /explain analyse SELECT '12.11.2007 18:04:00 UTC' AS zeit, 'M' AS datatyp, p.zs_nr AS zs_de, j_ges, de_mw_abh_j_lkw(mw_abh) ...
    Thomas ZaksekThomas Zaksek
    Feb 11, 2008 at 6:08 pm
    Feb 14, 2008 at 11:51 pm
  • Hi I have discovered an issue on my Postgresql database recently installed : it seems that the optimizer can not, when possible, simplify and rewrite a simple query before running it. Here is a ...
    SURANTYN Jean FrançoisSURANTYN Jean François
    Feb 6, 2008 at 8:42 am
    Feb 11, 2008 at 4:45 pm
  • Hello, my impression has been that in the past, there has been a general semi-consensus that upping shared_buffers to use the majority of RAM has not generally been recommended, with reliance on the ...
    Peter SchullerPeter Schuller
    Feb 15, 2008 at 12:35 pm
    Feb 18, 2008 at 9:24 pm
  • Hi, I want to disable Write Ahead Log (WAL) completely because of following reasons, 1. I am running Linux on the Compact Flash, which has limited memory; I can't afford disk space of 32MB for ...
    Kathirvel, JeevanandamKathirvel, Jeevanandam
    Feb 18, 2008 at 9:12 am
    Feb 19, 2008 at 3:50 pm
  • Hi all, I've been reading through the performance list of the last few months, and haven't been able to find a solution to my problem yet, so I'm posting the specifics here now. If anyone can suggest ...
    Michael LorenzMichael Lorenz
    Feb 14, 2008 at 6:28 pm
    Feb 15, 2008 at 2:47 pm
  • I've got a lot of rows in one table and a lot of rows in another table. I want to do a bunch of queries on their join column. One of these is like this: t1.col like '%t2.col%' I know that always ...
    Dan KaplanDan Kaplan
    Feb 27, 2008 at 7:47 pm
    Mar 1, 2008 at 2:10 am
  • We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some playing around with various settings. So far, we've (I say we, but it's another guy doing the work) found that open_datasync seems ...
    Dan LangilleDan Langille
    Feb 15, 2008 at 9:56 pm
    Feb 19, 2008 at 10:58 pm
  • Hi, I am using Postgres 8.2.4, we have to regularly run some queries on some big tables to see if we have any data for a particular request. But sometimes we might not have any matching rows on a ...
    Pallav KalvaPallav Kalva
    Feb 12, 2008 at 9:36 pm
    Feb 13, 2008 at 8:52 pm
  • We have a large datawarehouse stored in postgres and temp tables are created based on user query. The process of temp table creation involves selecting data from main fact table, this includes ...
    Linux GuruLinux Guru
    Feb 11, 2008 at 11:07 am
    Feb 13, 2008 at 10:59 am
  • Hello, I've been wrestling w/ a complex query for another developer for awhile today. The problem consistently seems to a mis-estimation of the number of rows resulting from a join. This causes the ...
    Chris KratzChris Kratz
    Feb 11, 2008 at 10:24 pm
    Feb 20, 2008 at 11:07 am
  • Hi, While designing a complex database structure I wanted to ask a basic question about views. If I give an ORDER BY clause in a VIEW and then use it in another query where the VIEW's ORDER BY is ...
    Robins TharakanRobins Tharakan
    Feb 28, 2008 at 2:31 pm
    Feb 29, 2008 at 11:58 am
  • After reviewing http://www.postgresql.org/docs/8.3/static/sql-cluster.html a couple of times, I have some questions: 1) it says to run analyze after doing a cluster. i'm assuming autovacuum will take ...
    Douglas J HunleyDouglas J Hunley
    Feb 27, 2008 at 5:01 pm
    Feb 27, 2008 at 7:34 pm
  • Hi members I am looking for an example of a web application (WAR) which executea a Postgres actions. This aims to test the performance of Postgres in Web mode. I shall be grateful if someone gives me ...
    Mohamed Ali JBELIMohamed Ali JBELI
    Feb 17, 2008 at 11:21 am
    Feb 17, 2008 at 4:21 pm
  • I want to create and update two tables in a function such as below, but using parameters as tablename is not allowed and gives an error. Is there any way I could achieve this? CREATE OR REPLACE ...
    Linux GuruLinux Guru
    Feb 13, 2008 at 2:25 pm
    Feb 15, 2008 at 2:14 pm
  • We have a web application for which we intend to run the database on a dedicated server. We hope by the end of 2008 to have 10 companies accessing 10 instances of the database for this application. ...
    Rory Campbell-LangeRory Campbell-Lange
    Feb 13, 2008 at 1:12 pm
    Feb 13, 2008 at 5:38 pm
  • I've got some long running queries, and want to tune them. Using simple logic, I can understand what expensive steps in the query plan ought to be (seq scan and index scans using much rows), but I ...
    Frits HooglandFrits Hoogland
    Feb 27, 2008 at 10:18 am
    Feb 27, 2008 at 5:36 pm
  • Hi all, i have strange problem with performance in PostgreSQL (8.1.9). My problem shortly: I'm using postgreSQL via JDBC driver (postgresql-8.1-404.jdbc3.jar) and asking the database for search on ...
    Pavel RotekPavel Rotek
    Feb 25, 2008 at 10:06 am
    Feb 26, 2008 at 1:41 pm
  • Hi, I need to store a lot of 3-tuples of words (e.g. "he", "can", "drink"), order matters! The source is about 4 GB of these 3-tuples. I need to store them in a table and check whether one of them is ...
    Moritz OnkenMoritz Onken
    Feb 22, 2008 at 3:42 pm
    Feb 23, 2008 at 9:35 am
  • Once per quarter, we need to load a lot of data, which causes many updates across the database. We have an online transaction processing-style application, which we really want to stay up during the ...
    David CraneDavid Crane
    Feb 15, 2008 at 1:15 am
    Feb 15, 2008 at 1:38 am
  • Hi all... If ssl is enable in postgresql decreanse the performance of the database? How much? Thanks in advance
    Fabrix peñuelasFabrix peñuelas
    Feb 11, 2008 at 11:58 pm
    Feb 12, 2008 at 5:46 pm
  • Hi, I'm having a performance problem on a request using Tsearch2: the request strangely takes several minutes. I've tried to follow Tsearch tuning recommendations, I've searched through the archives, ...
    Viviane LesticViviane Lestic
    Feb 5, 2008 at 11:47 am
    Feb 5, 2008 at 3:10 pm
  • Hello I am testing one server and I found strange behave of 8.2.6. My configuration is: Linux Orbisek 2.6.18-xeonsmp #1 SMP Thu Jan 31 14:09:15 CET 2008 i686 GNU/Linux, 4 x Intel(R) Xeon(R) CPU E5335 ...
    Pavel StehulePavel Stehule
    Feb 3, 2008 at 4:02 pm
    Feb 3, 2008 at 9:18 pm
  • Hi, You may remember some thread about data loading performances and multi-threading support in pgloader: http://archives.postgresql.org/pgsql-performance/2008-02/msg00081.php The pgloader code to ...
    Dimitri FontaineDimitri Fontaine
    Feb 26, 2008 at 12:31 pm
    Mar 10, 2008 at 4:08 pm
  • I have a cascading delete trigger that is obviously using a seqscan. (Explain analyze shows that trigger as taking over 1000s while all other triggers are <1s. The value in test delete didn't even ...
    Andrew LazarusAndrew Lazarus
    Feb 25, 2008 at 9:02 pm
    Feb 28, 2008 at 12:23 am
  • Hi I am using Postgres8.3 on 8G memory , Xeon X5355 Quad Core x 2 processer RH5 machine with 10G data. (with some table which have about 2,000,000~ 5,000,000 rows ) I have two quesion. 1. how to set ...
    Bh yuanBh yuan
    Feb 21, 2008 at 5:13 am
    Feb 21, 2008 at 12:24 pm
  • Folks, Does anyone know if HOT is compatible with pg_toast tables, or do TOASTed rows simply get excluded from HOT? I can run some tests, but if someone knows this off the top of their heads it would ...
    Josh BerkusJosh Berkus
    Feb 13, 2008 at 5:57 pm
    Feb 13, 2008 at 11:05 pm
  • Hello, I'm planning to cluster a few large tables in our database but I'm unable to find any recommendations/documentation on best practices -- Mainly, whether it's better to use an index which has a ...
    SalmanSalman
    Feb 11, 2008 at 8:03 pm
    Feb 12, 2008 at 2:42 am
  • I am using Postgres 8.2.5. I have a table that has rows containing a variable length array with a known maximum. I was doing selects on the array elements using an ANY match. The performance was not ...
    Andrew klassenAndrew klassen
    Feb 7, 2008 at 6:38 pm
    Feb 7, 2008 at 7:02 pm
  • I've got a lot of rows in one table and a lot of rows in another table. I want to do a bunch of queries on their join column. One of these is like this: t1.col like '%t2.col%' I know that always ...
    Dan KaplanDan Kaplan
    Feb 27, 2008 at 7:47 pm
    Feb 27, 2008 at 8:26 pm
  • SORRY - these are the commands (i.e. pgserver-A and pgserver-B) ====== Hi - I'm wondering if anyone has had success doing a simultaneous load of one Pg dump to two different servers? The load command ...
    Susan RussoSusan Russo
    Feb 22, 2008 at 7:11 pm
    Feb 25, 2008 at 1:32 pm
  • Given the following query: SELECT fi.pub_date FROM ext_feeder_item fi WHERE fi.feed_id IN (SELECT id FROM ext_feeder_feed ff WHERE ff.is_system) ORDER BY pub_date DESC; I'm getting a plan that uses a ...
    Markus BertheauMarkus Bertheau
    Feb 21, 2008 at 7:04 am
    Feb 21, 2008 at 8:34 am
  • Hi, I am using Postgresql 8.1 for handling large data. I am having One Parent Table and Child Table I.e.inherits from parent table. The constraint for partitioning table is date range. I have to ...
    Shilpa RaghavendraShilpa Raghavendra
    Feb 20, 2008 at 11:02 am
    Feb 20, 2008 at 11:38 am
  • Is there a way I can change where postgres writes it temporary files? My data directory is on a slow array, but we also have a fast array. I'm looking to get all the temp file creation onto the fast ...
    Nikolas EverettNikolas Everett
    Feb 18, 2008 at 3:27 pm
    Feb 18, 2008 at 4:10 pm
  • Hi, Assuming two or more clients issue INSERTs and COPYs on the same table in the database at the same time, does PostgreSQL execute them in parallel (i.e. no table-level locks, etc.) assuming there ...
    Ivan VorasIvan Voras
    Feb 8, 2008 at 10:50 pm
    Feb 9, 2008 at 4:19 am
  • Hi, I have 2 questions regarding the storage optimization done by Postgres: 1) Is a NULL value optimized for storage. If I have a timestamp (or some such) field that I set to default NULL, will it ...
    Gangadharan S.A.Gangadharan S.A.
    Feb 1, 2008 at 8:44 am
    Feb 2, 2008 at 6:37 am
  • Hi - I'm wondering if anyone has had success doing a simultaneous load of one Pg dump to two different servers? The load command is actually run from two different workstations, but reading the same ...
    Susan RussoSusan Russo
    Feb 22, 2008 at 7:11 pm
    Feb 22, 2008 at 7:11 pm
  • I was thinking that we almost need a matrix of versions and small, typical, large, and too big or whatever for each version, and which hardware configs. max_connections is the one I see abused a lot ...
    Scott MarloweScott Marlowe
    Feb 22, 2008 at 12:24 am
    Feb 22, 2008 at 12:24 am
  • Hi, This occurs on postgresql 8.2.5. I'm a bit at loss with the plan chosen for a query : The query is this one : SELECT SULY_SAOEN.SAOEN_ID, SULY_SDCEN.SDCEN_REF, SULY_SDCEN.SDCEN_LIB, ...
    Cousin MarcCousin Marc
    Feb 19, 2008 at 3:28 pm
    Feb 19, 2008 at 3:28 pm
  • Hi all, When I'm doing an explain analyze to a query of mine I notice that the number of estimated rows by the planner is a lot smaller then the actual number of rows, I'm afraid that this make my ...
    Yonatan Ben-NesYonatan Ben-Nes
    Feb 8, 2008 at 12:12 pm
    Feb 8, 2008 at 12:12 pm
  • Hi, (PostgreSQL 8.3) I'm trying to optimize one of the most often used queries in our system: (Full minimized pastable schema and data below.) create table feeds_users ( user_id int references ...
    Markus BertheauMarkus Bertheau
    Feb 7, 2008 at 2:52 pm
    Feb 7, 2008 at 2:52 pm
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions50
posts409
users103
websitepostgresql.org
irc#postgresql

103 users for February 2008

Tom Lane: 41 posts Matthew: 22 posts Greg Smith: 19 posts Scott Marlowe: 19 posts Simon Riggs: 14 posts Douglas J Hunley: 13 posts Dimitri Fontaine: 12 posts Jignesh K. Shah: 11 posts Richard Huxton: 11 posts Erik Jones: 9 posts Joel Stevenson: 9 posts Greg Stark: 8 posts Sean Leach: 8 posts Dave Cramer: 7 posts Dean Gibson (DB Administrator): 7 posts Joshua D. Drake: 7 posts Linux Guru: 7 posts Jeff Davis: 6 posts Kynn Jones: 6 posts Laurent Raufaste: 6 posts
show more
Archives