FAQ

PostgreSQL > pgsql-performance > November 2008

Search Discussions

38 discussions - 306 posts

  • Query below seems to use indexes everywhere in most optimal way. dokumnr column is of type int Speed of this query varies rapidly: In live db fastest response I have got is 8 seconds. Re-running same ...
    AndrusAndrus
    Nov 19, 2008 at 8:40 pm
    Nov 24, 2008 at 9:16 pm
  • We recently upgraded the databases for our circuit court applications from PostgreSQL 8.2.5 to 8.3.4. The application software didn't change. Most software runs fine, and our benchmarks prior to the ...
    Kevin GrittnerKevin Grittner
    Nov 5, 2008 at 6:45 pm
    Nov 11, 2008 at 3:07 pm
  • Both queries return same result (19) and return same data. Pattern query is a much slower (93 sec) than equality check (13 sec). How to fix this ? Using 8.1.4, utf-8 encoding, et-EE locale. Andrus. ...
    AndrusAndrus
    Nov 22, 2008 at 8:41 pm
    Nov 28, 2008 at 2:58 pm
  • Hello. For a long time already I can see very poor OR performance in postgres. If one have query like "select something from table where condition1 or condition2" it may take ages to execute while ...
    ІцвРЫцЩ ВШЬзШиШЭІцвРЫцЩ ВШЬзШиШЭ
    Nov 5, 2008 at 11:12 am
    Nov 17, 2008 at 9:52 am
  • Hi, I have table with cca 60.000 rows and when I run query as: Update table SET column=0; after 10 minutes i must stop query, but it still running :( I've Postgres 8.1 with all default settings in ...
    FireroxFirerox
    Nov 10, 2008 at 4:30 pm
    Nov 16, 2008 at 2:56 pm
  • Hi chaps, I've had this old card sitting on my desk for a while. It appears to be a U160 card with 128Mb BBU so I thought I'd wang it in my test machine (denian etch) and give it a bash. I set up 4 ...
    Glyn AstillGlyn Astill
    Nov 22, 2008 at 2:18 pm
    Nov 24, 2008 at 5:02 pm
  • Why is this view 9x slower than the base table? [email protected]=# explain analyze select count(*) from loan_tasks_committed; QUERY PLAN ...
    Jim 'Decibel!' NasbyJim 'Decibel!' Nasby
    Nov 10, 2008 at 8:26 am
    Nov 12, 2008 at 2:34 am
  • Index is not used for is null condition: create index makse_dokumnr_idx on makse(dokumnr); explain select sum( summa) from MAKSE where dokumnr is null "Aggregate (cost=131927.95..131927.96 rows=1 ...
    AndrusAndrus
    Nov 11, 2008 at 8:36 pm
    Nov 13, 2008 at 12:27 am
  • Group by using CHAR columns takes abnormally big time. How to speed it ? Andrus. 8.1.4, cluster locale is en-us, db encoding is utf-8 set search_path to firma2,public; explain analyze SELECT CASE ...
    AndrusAndrus
    Nov 28, 2008 at 3:12 pm
    Nov 30, 2008 at 1:02 pm
  • Hi folks, I have a simple table that keeps track of a user's access history. It has a a few fields, but the important ones are: - ownerId: the user's ID, a int8 - accessTS: the timestamp of the ...
    Dimi PaunDimi Paun
    Nov 17, 2008 at 4:26 pm
    Nov 17, 2008 at 8:47 pm
  • Hi All; I've installed pg_buffercache and I want to use it to help define the optimal shared_buffers size. Currently I run this each 15min via cron: insert into buffercache_stats select now(), ...
    Kevin KempterKevin Kempter
    Nov 24, 2008 at 6:49 pm
    Nov 25, 2008 at 7:38 pm
  • Dear List, I would like to improve seq scan performance. :-) I have many cols in a table. I use only 1 col for search on it. It is indexed with btree with text_pattern_ops. The search method is: r ...
    Lutischán FerencLutischán Ferenc
    Nov 10, 2008 at 6:50 am
    Nov 17, 2008 at 10:51 am
  • I've been searching for performance metrics and tweaks for a few weeks now. I'm trying to determine if the length of time to process my queries is accurate or not and I'm having a difficult time ...
    - -- -
    Nov 12, 2008 at 4:27 pm
    Nov 16, 2008 at 3:19 pm
  • Hello ! Sorry for the subject, I didn't found a better one ! :-/ I'm having a problem with this query (below) that takes betweend 14 and 15 seconds to run, which is too long for the end-user. I've ...
    Bruno BaguetteBruno Baguette
    Nov 13, 2008 at 12:10 pm
    Nov 13, 2008 at 6:02 pm
  • There are columns kuupaev date, cr char(10), db char(10) and regular indexes for all those fields. bilkaib table contains large number of rows. The following query takes too much time. How to make it ...
    AndrusAndrus
    Nov 12, 2008 at 5:06 pm
    Nov 12, 2008 at 8:06 pm
  • I have a problem with partitioning and I'm wondering if anyone can provide some insight. I'm trying to find the max value of a column across multiple partitions. The query against the partition set ...
    Greg JamanGreg Jaman
    Nov 26, 2008 at 4:07 am
    Dec 2, 2008 at 12:00 pm
  • Hey all, This may be more of a Linux question than a PG question, but I'm wondering if any of you have successfully allocated more than 8 GB of memory to PG before. I have a fairly robust server ...
    Ryan HansenRyan Hansen
    Nov 26, 2008 at 10:10 pm
    Nov 28, 2008 at 10:28 pm
  • There are indexes on rid(dokumnr) and dok(dokumnr) and dokumnr is int. Instead of using single key index, 8.1.4 scans over whole rid table. Sometimes idtelluued can contain more than single row so ...
    AndrusAndrus
    Nov 22, 2008 at 8:41 pm
    Nov 23, 2008 at 12:41 pm
  • Hi, I have a problem with large objects in postgresql 8.1: The performance of loading large objects into a database goes way down after a few days of operation. I have a cron job kicking in twice a ...
    Vegard BønesVegard Bønes
    Nov 25, 2008 at 12:54 pm
    Nov 28, 2008 at 3:32 pm
  • Adding limit clause causes very slow query: explain analyze select * from firma2.dok where doktyyp='J' order by dokumnr limit 100 "Limit (cost=0.00..4371.71 rows=100 width=1107) (actual ...
    AndrusAndrus
    Nov 23, 2008 at 9:41 pm
    Nov 24, 2008 at 11:10 pm
  • Hi. I have a Perl script whose main loop generates thousands of SQL updates of the form UPDATE edge SET keep = true WHERE node1 IN ( $node_list ) AND node2 = $node_id; ...where here $node_list stands ...
    Kynn JonesKynn Jones
    Nov 18, 2008 at 3:53 pm
    Nov 21, 2008 at 1:35 am
  • Hello. It's second query rewrite postgresql seems not to handle - making EXCEPT from NOT IT. Here is an example: Preparation: drop table if exists t1; drop table if exists t2; create temporary table ...
    ІцвРЫцЩ ВШЬзШиШЭІцвРЫцЩ ВШЬзШиШЭ
    Nov 19, 2008 at 11:51 am
    Nov 19, 2008 at 3:12 pm
  • Hi, I have defined sequence on a table something like this CREATE SEQUENCE items_unqid_seq INCREMENT 1 MINVALUE 0 MAXVALUE 9223372036854775807 START 7659 CACHE 1; this is on a table called items. ...
    Kranti™ K K ParisaKranti™ K K Parisa
    Nov 19, 2008 at 3:54 pm
    Nov 20, 2008 at 5:04 am
  • Hello, I've had the feeling for a while that the pg_stat_bgwriter statistics doesn't work quite the way I have understood it (based on the excellent [1] and the pg docs). I am now monitoring a ...
    Peter SchullerPeter Schuller
    Nov 5, 2008 at 12:38 pm
    Nov 6, 2008 at 11:04 pm
  • Hello, I have following common situation: Category IDs: about 50 000 Document IDs: about 3 000 000 Many to many relationship. A document id have a relation with 10 up to 1000 category ids One query, ...
    Chavdar KopoevChavdar Kopoev
    Nov 26, 2008 at 3:38 pm
    Nov 27, 2008 at 4:40 pm
  • Hi All; I'm looking for tips / ideas per performance tuning some specific queries. These are generally large tables on a highly active OLTP system (100,000 - 200,000 plus queries per day) First off, ...
    Kevin KempterKevin Kempter
    Nov 27, 2008 at 4:50 am
    Nov 27, 2008 at 10:09 am
  • I have a database in a production server (8.1.9) with to schema containing the sames table same index, same every thing, but with different data. When I execute a query in one schema, it take much ...
    Patrice BeliveauPatrice Beliveau
    Nov 14, 2008 at 4:29 pm
    Nov 14, 2008 at 5:14 pm
  • I found that simple IN query on indexed tables takes too much time. dok and rid have both indexes on int dokumnr columnr and dokumnr is not null. PostgreSql can use index on dok or event on rid so it ...
    AndrusAndrus
    Nov 10, 2008 at 4:25 pm
    Nov 10, 2008 at 6:23 pm
  • I am struggeling with the following query which fetches a random subset of 200 questions that matches certain tags within certain languages. However, the query takes forever to evaluate, even though ...
    TmpTmp
    Nov 30, 2008 at 7:12 pm
    Dec 1, 2008 at 1:30 pm
  • ok, I have an application that I am trying to speed up. Its a reporting application that makes heavy use of the crosstab function. Here is some of the setup / configuration details: Postgres 8.3.3 ...
    Jeremiah ElliottJeremiah Elliott
    Nov 13, 2008 at 8:42 pm
    Nov 13, 2008 at 11:06 pm
  • Hi all My database server db01 is on linux environment and size of base folder increasing very fast unexpectedly(creating renamed files of 1 GB in base folder like 1667234568.10) details as below ...
    Brahma tiwariBrahma tiwari
    Nov 6, 2008 at 10:51 am
    Nov 6, 2008 at 11:57 am
  • So, we had a query run accidentally without going through the right checks to ensure that it had the right limits in a where clause for our table partitioning, resulting in an attempt to scan TB's of ...
    Scott CareyScott Carey
    Nov 5, 2008 at 8:37 pm
    Nov 5, 2008 at 10:19 pm
  • Hi, I have to manage a database that is getting way too big for us. Currently db size is 304 GB. One table is accounting for a third of this space. The table itself has 68.800.000 tuples, taking ...
    Franck RoutierFranck Routier
    Nov 12, 2008 at 10:28 pm
    Nov 12, 2008 at 11:44 pm
  • Hello , I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux (Linux version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red Hat 4.3.0-8) (GCC) ) #1 SMP Thu May 1 ...
    PraveenPraveen
    Nov 4, 2008 at 2:17 pm
    Nov 4, 2008 at 2:43 pm
  • Hi, I have a small problem. I have one view which sum's a another tables field and uses that sum for several things including filtering. Every time it uses the that summarised field in other queries ...
    Martin KjeldsenMartin Kjeldsen
    Nov 4, 2008 at 10:56 am
    Nov 4, 2008 at 1:39 pm
  • explain analyze SELECT sum(1) FROM dok JOIN rid USING (dokumnr) WHERE dok.kuupaev ='2008-05-01' and ( ( dok.doktyyp IN ('V','G','Y','K','I','T','D','N','H','M','E','B','A','R','C','F','J','Q') AND ...
    AndrusAndrus
    Nov 30, 2008 at 8:42 pm
    Nov 30, 2008 at 8:42 pm
  • Hi All, Thank you all in advance for your answers. My application does bulk inserts on a table (50,000 rows concurrently by 10 threads), There are 3 indexes on the table whose update takes a lot of ...
    Anshul DuttaAnshul Dutta
    Nov 10, 2008 at 5:21 pm
    Nov 10, 2008 at 5:21 pm
  • Dear All, Recently i have released the next version of the epqa. which is a very useful tool for, gives input for optimizing psql queries, and fine tuning it. epqa is tool similar like, pqa. But ...
    Sathiya psqlSathiya psql
    Nov 4, 2008 at 12:25 pm
    Nov 4, 2008 at 12:25 pm
Nov 2008
Group Navigation
period‹ prev | Nov 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions38
posts306
users74
websitepostgresql.org
irc#postgresql

74 users for November 2008

Andrus: 45 posts Scott Marlowe: 24 posts Tom Lane: 21 posts Tomas Vondra: 19 posts Richard Huxton: 15 posts PFC: 14 posts Scott Carey: 12 posts ІцвРЫцЩ ВШЬзШиШЭ: 11 posts Kevin Grittner: 10 posts Vladimir Sitnikov: 7 posts Jim 'Decibel!' Nasby: 6 posts Matthew Wakeling: 6 posts David Rees: 5 posts Glyn Astill: 5 posts Greg Smith: 5 posts Firerox: 4 posts Alvaro Herrera: 4 posts Andreas Kretschmer: 4 posts Bruno Baguette: 4 posts Craig Ringer: 4 posts
show more
Archives