FAQ

PostgreSQL > pgsql-performance > June 2008

Search Discussions

30 discussions - 249 posts

  • Hello to list, We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling with postgresql performance. Any query say select * from tablename takes 10-15 mins to give the output, and ...
    Bijayant kumarBijayant kumar
    Jun 23, 2008 at 11:06 am
    Jun 26, 2008 at 10:20 pm
  • Hi Has anyone done some benchmarks between hardware RAID vs Linux MD software RAID? I'm keen to know the result. -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. ...
    Adrian MoiseyAdrian Moisey
    Jun 25, 2008 at 11:05 am
    Jun 27, 2008 at 1:16 pm
  • Hi, I am looking to improve the initial query speed for the following query: select email_id from email, to_tsquery('default','example') as q where q@@fts; This is running on 8.2.4 on Windows Server ...
    Howard ColeHoward Cole
    Jun 16, 2008 at 5:57 pm
    Jun 20, 2008 at 1:13 pm
  • Hi, I need to install a 8.3 database and was wondering which hardware would be sufficient to have good performances (less than 30s for² slowest select). Database size: 25 Go /year, 5 years of history ...
    LionelLionel
    Jun 17, 2008 at 2:06 pm
    Jun 20, 2008 at 11:07 am
  • Hi list, We have a database with lots of small simultaneous writes and reads (millions every day) and are looking at buying a good hardware for this. What are your suggestions. What we are currently ...
    HenrikHenrik
    Jun 25, 2008 at 10:16 am
    Jun 27, 2008 at 6:23 am
  • Running postgres 8.2.5 I have a table that has 5 indices, no foreign keys or any dependency on any other table. If delete the database and start entering entries, everything works very well until I ...
    Andrew klassenAndrew klassen
    Jun 3, 2008 at 10:42 pm
    Jun 5, 2008 at 6:18 am
  • Hi, I am new to SQL and have two tables..., "processor" and "users_processors". The first table contains Processors: CREATE TABLE processor ( id SERIAL, speed varchar(50) NOT NULL, type int2 NOT ...
    UlrichUlrich
    Jun 28, 2008 at 3:22 pm
    Jul 5, 2008 at 12:14 pm
  • Hi, I have a query select count(*) from result where exists (select * from item where item.url LIKE result.url || '%' limit 1); which basically returns the number of items which exist in table result ...
    Moritz OnkenMoritz Onken
    Jun 28, 2008 at 4:54 pm
    Jun 30, 2008 at 4:42 pm
  • Hello, I am experiencing a query for which an useful index is not being used by PostgreSQL. The query is in the form: select count(*) from foo where foo.account_id in ( select id from accounts where ...
    Daniele VarrazzoDaniele Varrazzo
    Jun 19, 2008 at 1:13 am
    Jul 20, 2008 at 11:07 pm
  • Hello, my understanding, and generally my experience, has been that VACUUM and VACUUM ANALYZE (but not VACUUM FULL) are never supposed to block neither SELECT:s nor UPDATE:s/INSERT:s/DELETE:s to a ...
    Peter SchullerPeter Schuller
    Jun 30, 2008 at 3:06 pm
    Jul 1, 2008 at 3:27 pm
  • Hi List; Anyone have any experiences to share per setting up a federated architecture with PostgreSQL ? I wonder if the dblink contrib works well in a federated scenario, specifically in the setup of ...
    Kevin kempterKevin kempter
    Jun 26, 2008 at 8:40 pm
    Jun 30, 2008 at 1:52 pm
  • Hello, I have been searching on the net on how to tune and monitor performance of my postgresql server but not met with success. A lot of information is vague and most often then not the answer is ...
    Nikhil G. DaddikarNikhil G. Daddikar
    Jun 27, 2008 at 2:48 pm
    Jul 28, 2008 at 8:19 pm
  • I'm having a strange problem with a query. The query is fairly simple, with a few constants and two joins. All relevant columns should be indexed, and I'm pretty sure there aren't any type conversion ...
    John BeaverJohn Beaver
    Jun 29, 2008 at 9:52 pm
    Jul 1, 2008 at 12:39 am
  • Hello, I have a table (transactions) containing 61 414 503 rows. The basic count query (select count(transid) from transactions) takes 138226 milliseconds. This is the query analysis output: ...
    Marcin CitowickiMarcin Citowicki
    Jun 3, 2008 at 8:18 am
    Jun 5, 2008 at 8:23 pm
  • I have a Windows application which connects to a Postgres (8.3) database residing on our company server. Most of the application's users work from their homes, so the application was developed with a ...
    Lewis KapellLewis Kapell
    Jun 4, 2008 at 2:53 pm
    Jun 6, 2008 at 3:01 pm
  • Hi, I got a question about scalability in high volume insert situation where the table has a primary key and several non-unique indexes on other columns of the table. How does PostgreSQL behave in ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Jun 11, 2008 at 9:59 am
    Jun 11, 2008 at 2:13 pm
  • Hi, I have problems with my database becoming huge in size (around 150 GB right now, and 2/3 for only three tables, each having around 30 millions tuples. Space is spent mainly on indices.). I have a ...
    Franck RoutierFranck Routier
    Jun 30, 2008 at 5:46 pm
    Jul 1, 2008 at 3:34 pm
  • As i've been looking over the more complicated queries that i have written and gotten allot of help in redoing the quires from you all, thanks again. I have noticed that estimated Cost to do the ...
    JustinJustin
    Jun 2, 2008 at 9:43 pm
    Jun 3, 2008 at 3:13 am
  • One of the things to hit my mailbox this week is from someone who is frustrated not only by their database server but by issues sending messages to this list; I'm forwarding to here for them, please ...
    Greg SmithGreg Smith
    Jun 6, 2008 at 6:30 am
    Jun 23, 2008 at 10:42 pm
  • Hi, I read a lot about postgres tuning and did some of it. But one of the things, when you start tuning a system that is completely new to you, is checking which sql statement(s) cost most of the ...
    Uwe BartelsUwe Bartels
    Jun 15, 2008 at 1:48 pm
    Jun 15, 2008 at 3:00 pm
  • We run GCC-compiled postgresql on a number of HP-UX and Linux boxes. Our measurements to date show 8.3.1 performance to be about 30% *worse* than 8.2 on HP-UX for the same "drink the firehose" ...
    Josh RoveroJosh Rovero
    Jun 12, 2008 at 1:56 am
    Jun 12, 2008 at 1:25 pm
  • All, While running a Select query we get the below error: ERROR: out of memory DETAIL: Failed on request of size 192. Postgres Conf details: shared_buffers = 256000 work_mem =150000 max_stack_depth = ...
    Nimesh SatamNimesh Satam
    Jun 30, 2008 at 4:20 am
    Jun 30, 2008 at 6:59 am
  • Hi all, I need to specify servers and storage to run PostgreSQL. Does anyone know any source of information (articles, presentations, books, etc.) which describes methods of hardware sizing for ...
    Sérgio R F OliveiraSérgio R F Oliveira
    Jun 27, 2008 at 5:56 pm
    Jun 29, 2008 at 7:04 pm
  • Tengo una pregunta, y este es el escenario de lo que tengo Se crea una instancia de postgreSQL Se crea un directorio $PGDATA/walback donde se almacenararn los wal antiguos Se exporta una variable ...
    Antonio PerezAntonio Perez
    Jun 18, 2008 at 7:43 pm
    Jun 19, 2008 at 7:13 am
  • Dear All, Am going to do migration of database from one version to another., is there any article or any other document explaining the possibilities and other things. Further Explanation: I have a ...
    Sathiya psqlSathiya psql
    Jun 17, 2008 at 1:14 pm
    Jun 17, 2008 at 1:23 pm
  • Hi, In my pgsql procedure, i use the function geometryDiff := difference (geometry1,geometry2); but this function is very slow!!! What can I do to speed this function? Exists a special index for it? ...
    Luke 78Luke 78
    Jun 16, 2008 at 9:06 am
    Jun 16, 2008 at 7:26 pm
  • Hi, Am I wrong or AGE() always gets directed to a sequential scan? # BEGIN; ] SET enable_seqscan TO off; ] EXPLAIN ANALYZE ] SELECT count(1) ] FROM incomingmessageslog ] WHERE AGE(time) < '1 year'; ] ...
    Volkan YAZICIVolkan YAZICI
    Jun 6, 2008 at 1:21 pm
    Jun 8, 2008 at 6:12 am
  • hello, I am wondering if actually, does exists any rule to determine the amount of RAM, according to the hardware disk size (in prevision to use all or nearly available space), when designing a ...
    Mathieu GilardetMathieu Gilardet
    Jun 4, 2008 at 2:08 pm
    Jun 5, 2008 at 12:52 am
  • The query optimizer fails to use a hash aggregate most of the time. This is an inconsistent behavior -- the queries below were happily using hash_aggregate on a previous pg_restore from the data. On ...
    Scott CareyScott Carey
    Jun 25, 2008 at 9:07 pm
    Jun 25, 2008 at 9:07 pm
  • Hi, i'm new to this ML, i'll try to explain my issue: I've two tables defined as is (postgresql 8.1): CREATE TABLE table1 ( _id serial, num1 int4 not null, num2 int4 not null, primary key(_id) ); ...
    CiskoCisko
    Jun 18, 2008 at 4:18 pm
    Jun 18, 2008 at 4:18 pm
Jun 2008
Group Navigation
period‹ prev | Jun 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions30
posts249
users84
websitepostgresql.org
irc#postgresql

84 users for June 2008

Matthew Wakeling: 20 posts Scott Marlowe: 20 posts Greg Smith: 19 posts Tom Lane: 11 posts Howard Cole: 9 posts Merlin Moncure: 7 posts Moritz Onken: 7 posts Andrew Sullivan: 6 posts Tv: 5 posts Alvaro Herrera: 5 posts Andrew klassen: 5 posts Bijayant kumar: 5 posts Henrik: 5 posts John Beaver: 5 posts Jonah H. Harris: 5 posts Lionel: 4 posts Peter T. Breuer: 4 posts PFC: 4 posts Rusty Conover: 4 posts Ulrich: 4 posts
show more
Archives