[PERFORM] Use of * affect the performance

Hi, I always think that use of * in SELECT affected in the performance, becoming the search slowest. But I read in the a Postgres book's that it increases the speed of search. And now What the more fast? Thanks ---(end of broadcast)--- TIP 5

[PERFORM] Use of Stored Procedures and

Hi, I already read the documentation for to use the SPI_PREPARE and SPI_EXEC... but sincerely I don't understand how I will use this resource in my statements. I looked for examples, but I din't good examples :(.. Somebody can help me? Thanks. Marcos.

[PERFORM] Simple Question of Performance ILIKE or Lower

Hi, I have a simple question about performance using two resources. What's have the best performance? lower( col1 ) LIKE lower( 'myquestion%' ) OR col1 ILIKE 'myquestion%' Thanks. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PERFORM] Use of Stored Procedures and

> What statements? Sorry. Statements is my code. > What problem are you trying to solve? I want know how I make to use a prepared plan ( http://www.postgresql.org/docs/8.1/static/sql-prepare.html ). I read that I need to use the SPI_PREPARE and SPI_EXEC in my code, but I didn't understand how

Re: [PERFORM] Use of Stored Procedures and

> Which interface are you using to connect to PostgreSQL? libpq, libpqxx, > pgjdbc, python-popy? > > E. G. PGJDBC handles prepared plans transparently by using the > PreparedStatement class. > > If you use command line PSQL, you can use the PREPARE commands. I'm using the adodb to call the store

Re: [PERFORM] [PERFORMANCE] Stored Procedures

re-connecting is constant :(. Then the preprare not have very advantage because your duration is per session. Marcos. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

Re: [PERFORM] [PERFORMANCE] Stored Procedures

d how it's work I'm go read more about him. Thanks Marcos ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[PERFORM] Creating a correct and real benchmark

Hi, I'm developing a search engine using the postgresql's databas. I've already doing some tunnings looking increase the perform. Now, I'd like of do a realistic test of perfom with number X of queries for know the performance with many queries. What the corret way to do this? Thanks. ---

Re: [PERFORM] Creating a correct and real benchmark

Thanks for advises :-D. Marcos ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[PERFORM] Decide between Postgresql and Mysql (help of comunity)

timating many access simultaneous, then I think that the Postgresql is the best choice. Am I right? Our server have 1 GB of RAM, how many users can it support at the same time with this memory? Thanks in advanced Marcos ---(end of broadcast)--- TI

Re: [PERFORM] Decide between Postgresql and Mysql (help of

isc will be constant. Thanks :o) Marcos ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing l

[PERFORM] SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me.

07/12/2006 04:31 SQL_CALC_FOUND_ROWS in POSTGRESQL In mysqln i m using the command SQL_CALC_FOUND_ROWS in follow sintax. SELECT SQL_CALC_FOUND_ROWS name, email, tel FROM mytable WHERE name <> '' LIMIT 0, 10 to have the recorset data. and SELECT FOUND_ROWS(); to have the total of registers fou

Re: [PERFORM] PgPool II configuration with PostgreSQL 8.4

El 06/05/2010 6:17, Neha Mehta escribió:   Hi,   I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the system, it gives me an error, libpq is not installed or libpq is old.   I have tri

Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

El 07/05/2010 15:37, Mark Stosberg escribió: Hello, We've been a satified user of PostgreSQL for several years, and use it to power a national pet adoption website: http://www.adoptapet.com/ Recently we've had a regularly-timed middle-of-the-night problem where database handles are exhausted fo

Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

El 07/05/2010 16:10, Mark Stosberg escribió: You can use TRUNCATE instead DELETE. TRUNCATE is more efficient and faster that DELETE. Thanks for the suggestion. However, TRUNCATE is not compatible with Slony, and we also have some rows which remain in table. Now, we need more info

Re: [PERFORM] Server Configuration

Hot standby/Streaming Replication features with it. Here is a example of the configuration of PgPool-II 3.0.1 and PostgreSQL-9.0.2 http://lists.pgfoundry.org/pipermail/pgpool-general/2011-February/003338.html Regards -- Ing. Marcos Luís Ortíz Valmaseda System Engineer -- Database Administrato

Re: [PERFORM] i want to ask monitory peformance memory postgresql with automatically

the monitoring you will want to do is system level and is already supported by Nagios and similar tools. -- Marcos Luís Ortíz Valmaseda Software Engineer (UCI) http://marcosluis2186.posterous.com http://twitter.com/marcosluis2186 -- Sent via pgsql-performance mailing list (pgsql

Re: [PERFORM] postgresql.conf setting for max_fsm_pages

lot of performance improvements in the new versions. Is that any impact if i set the value to over 2M ? Thanks. Regards, Chio Chuan -- Marcos Luis Ortíz Valmaseda (@marcosluis2186) Data Engineer at UCI http://marcosluis2186.posterous.com 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERS

Re: [PERFORM] Slow Performance on a XEON E5504

On 08/24/2012 05:47 AM, Felix Schubert wrote: Hello List, I've got a system on a customers location which has a XEON E5504 @ 2.00GHz Processor (HP Proliant) It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram: The Postgres Performance on this system measured with pgbench is

Re: [PERFORM] AppScale backend datastore (NoSQL again kind of)

his, run some example apps, and see what's actually stored to get a handle on it. The GAE api for the datastore is sort of a ORM, w/ yet another query language, that seems to map to SQL better than to NoSQL, in any case. There seems to be a fairly explicit exposure of a table==class sort of map

Re: [PERFORM] 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets

could be found using git bisect of Linux, albiet laboriously. -- Marcos Luis Ortíz Valmaseda *Data Engineer && Sr. System Administrator at UCI* about.me/marcosortiz <http://about.me/marcosortiz> My Blog <http://marcosluis2186.posterous.com> Tumblr's blog <http://marcosor

Re: [PERFORM] problems with large objects dump

later pg_dump would you? Exactly what 8.4.x release is this, anyway? Tom, thanks for replying, yes, we tried it with postgres postgres 9.1 and 9.2 and the behavior is exactly the same. The production version is 8.4.9 Greetings, sergio. -- Marcos Luis O

Re: [PERFORM] Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

ttp://dba.stackexchange.com/questions/27893/increasing-work-mem-and-shared-buffers-on-postgres-9-2-significantly-slows-down but a few people suggested -- Marcos Luis Ortíz Valmaseda about.me/marcosortiz <http://about.me/marcosortiz> @marcosluis2186 <http://twitter.com/marc

[PERFORM] Thought you'd find this interesting

Hi! I’ve just learned about the water crisis and thought you would be interested to check out this story: https://waterforward.charitywater.org/et/FWIshxIN Let me know what you think! Thanks, Marcos -- Sent via WaterForward, an initiative of charity: water WaterForward, 387 Tehama

Re: [PERFORM] Horribly slow hash join

I didn't follow the conversation from the begining, bu I imagine that you could improve performance using the value (work_units % (2^32) ) instead of work_units. You could even make an index on this value. Like that, the HASH function will work well. This is not a good solution, but ... For exampl

Re: [PERFORM] SSD + RAID

This is very fast. On IT Toolbox there are many whitepapers about it. On the ERP and DataCenter sections specifically. We need that all tests that we do, we can share it on the Project Wiki. Regards On Nov 13, 2009, at 7:02 AM, Karl Denninger wrote: Laszlo Nagy wrote: Hello, I'm about to bu

Re: [PERFORM] random_page_cost = 2.0 on Heroku Postgres

st = 2.0 First execution of the queries with EXPLAIN ANALYZE - SET random_page_cost = 1.4 Second execution of the queries with EXPLAIN ANALYZE - SET random_page_cost = 1.2 Second execution of the queries with EXPLAIN ANALYZE And then, you can compare the pattern behind these queries executions Rega

Re: [PERFORM] random_page_cost = 2.0 on Heroku Postgres

project is alive, but we can ask to them (michael.glaesem...@myyearbook.com). http://area51.myyearbook.com Posuta can be a starting point for it. It uses Ruby and Clojure for core functionalities, jQuery/Flot for graphics, -- Marcos Luis Ortíz Valmaseda Sr. Software Engineer (UCI) http

Re: [PERFORM] 10K vs 15k rpm for analytics

OpenSolaris, FreeBSD and Mac OSX Server, and on Linux systems not What do you think about that? Regards -- ---- -- Ing. Marcos Luís Ortíz Valmaseda -- -- Twitter: http://twitter.com/@marcosluis2186--

Re: [PERFORM] Postgres DB maintainenance - vacuum and reindex

you can execute periodicly on you server, but if you don´t want to affect the production task, the best thing yo do is to drop the index and reissue the CREATE INDEX CONCURRENTLY command. Regards -- -- Ing. Marcos Luís Ortíz Valmaseda

Re: [PERFORM] Possible to improve query plan?

MB [O], [D] effective_cache_size = 2/3 RAM Regards Ing. Marcos Luís Ortíz Valmaseda Linux User # 418229 && PostgreSQL DBA Centro de Tecnologías Gestión de Datos (DATEC) http://postgresql.uci.cu http://www.postgresql.org http://it.toolbox.com/blogs/sql-apprentice - Mensaje

Re: [PERFORM] "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2

Query is : SELECT distinct m.id,coalesce(m.givenname,''), coalesce(m.midname,''), m.surname from marinerstates ms,vessels vsl,mariner m WHERE m.id=ms.marinerid and ms.vslid=vsl.id ANDms.state='Active' and coalesce(ms.endtime,now())::date >= '2006-07-15' ANDms.starttime::dat

Re: [PERFORM] Queries becoming slow under heavy load

pgpool. Which are the values for: - work_mem - shared_buffers - maintenance_work_mem - effective_cache_size - effective_io_concurrency - server_version Which are your platform? Regards -- Ing. Marcos Luís Ortíz Valmaseda System Engineer -- Database Administrator Centro de Tecnologías de Gestión

Re: [PERFORM] High load,

http://www.postgresql.org/mailpref/pgsql-performance -- Ing. Marcos Luís Ortíz Valmaseda System Engineer -- Database Administrator Centro de Tecnologías de Gestión de Datos (DATEC) Universidad de las Ciencias Informáticas http://postgresql.uci.cu -- Sent via pgsql-performance mailing l

Re: [PERFORM] [GENERAL] Strange performance degradation

Lorenzo Allegrucci escribió: Matthew Wakeling wrote: On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote: Anyway, how can I get rid those "idle in transaction" processes? Can I just kill -15 them or is there a less drastic way to do it? Are you crazy? Sure, if you want to destroy all of the changes

Re: [PERFORM] RAID card recommendation

Gurgel, Flavio escribió: - "Richard Neill" escreveu: Matthew Wakeling wrote: We're about to purchase a new server to store some of our old databases, and I was wondering if someone could advise me on a RAID card. We want to make a 6-drive SATA RAID arra

Re: [PERFORM] Queries within a function

-- "Para ser realmente grande, hay que estar con la gente, no por encima de ella." Montesquieu Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA && DW

Re: [PERFORM] Multiple data base on same server

elias ghanem escribió: Hi, I’m using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same server? -Each DB needs 10 tablespaces, so if I create 10 different

[PERFORM] Any have tested ZFS like PostgreSQL installation filesystem?

PostgreSQL installation fs? Regards. -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD) Universidad de las Ciencias Info

Re: [PERFORM] Any have tested ZFS like PostgreSQL installation filesystem?

Ivan Voras escribió: Ing . Marcos Luís Ortíz Valmaseda wrote: Regards to all the list. ZFS, the new filesystem developed by the Solaris Development team and ported to FreeBSD too, have many advantages that can do that all sysadmins are questioned about if it is a good filesystem to the

Re: [PERFORM] performance while importing a very large data set in to database

any case that you use it. 3- Then apply A CLUSTER command on the right tables that have these indexes. Regards -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA Centro de Tecnologías de Alm

Re: [PERFORM] Re: New server to improve performance on our large and busy DB - advice? (v2)

El 15/01/2010 14:43, Ivan Voras escribió: hi, You wrote a lot of information here so let's confirm in a nutshell what you have and what you are looking for: * A database that is of small to medium size (5 - 10 GB)? * Around 10 clients that perform constant write operations to the database (U

Re: [PERFORM] renice on an I/O bound box

El 19/01/2010 13:59, Willy-Bas Loos escribió: Hi, I have a query that runs for about 16 hours, it should run at least weekly. There are also clients connecting via a website, we don't want to keep them waiting because of long DSS queries. We use Debian Lenny. I've noticed that renicing the p

Re: [PERFORM] Limited Shared Buffer Problem

ork_mem,etc. My recommendation is to go down a little the shmmax and the shared_buffers values. Is very necessary that you have these values so high? Regards -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda

Re: [PERFORM] [GENERAL] PostgreSQL - case studies

ara ser realmente grande, hay que estar con la gente, no por encima de ella." Montesquieu Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA&& DWH -- BI Apprentice Centro de Tecnologías de Almacenamiento y Análisi