On 05/06/14 15:29, Igor Neyman wrote:
-Original Message-
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-
performance-ow...@postgresql.org] On Behalf Of Linos
Sent: Wednesday, June 04, 2014 6:10 PM
To: Merlin Moncure
Cc: pgsql-performance@postgresql.org
Subject: Re
Hello,
Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
started performing a lot slower, the query I am using in this example is pasted
here:
http://pastebin.com/71DjEC21
Considering it is a production database users are complaining because queries
are much slower
On 04/06/14 21:36, Merlin Moncure wrote:
On Wed, Jun 4, 2014 at 8:56 AM, Linos i...@linos.es wrote:
Hello,
Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
started performing a lot slower, the query I am using in this example is
pasted here:
http://pastebin.com
On 04/06/14 22:57, Merlin Moncure wrote:
On Wed, Jun 4, 2014 at 2:58 PM, Linos i...@linos.es wrote:
On 04/06/14 21:36, Merlin Moncure wrote:
On Wed, Jun 4, 2014 at 8:56 AM, Linos i...@linos.es wrote:
Hello,
Some days ago I upgraded from 8.4 to 9.3, after the upgrade some queries
started
Hello all,
I am trying to simplify some of the queries I use with my database creating a
big view of all the possible attributes my items can have, the view is rather
large:
http://pastebin.com/ScnJ8Hd3
I thought that Postgresql would optimize out joins on columns I don't ask for
when I use
On 16/04/14 17:57, Heikki Linnakangas wrote:
On 04/16/2014 06:13 PM, Linos wrote:
I thought that Postgresql would optimize out joins on columns I
don't ask for when I use the view but it doesn't, this query:
It doesn't, because it would be wrong. It still has to check that the tables
have
El 25/10/11 19:11, Merlin Moncure escribió:
On Tue, Oct 25, 2011 at 11:47 AM, Linos i...@linos.es wrote:
El 25/10/11 18:43, Tom Lane escribió:
Linos i...@linos.es writes:
i am having any problems with performance of queries that uses CTE,
can the
join on a CTE use the index
El 26/10/11 14:23, Merlin Moncure escribió:
On Wed, Oct 26, 2011 at 4:00 AM, Linos i...@linos.es wrote:
El 25/10/11 19:11, Merlin Moncure escribió:
On Tue, Oct 25, 2011 at 11:47 AM, Linos i...@linos.es wrote:
El 25/10/11 18:43, Tom Lane escribió:
Linos i...@linos.es writes:
i am having
Hi all,
i am having any problems with performance of queries that uses CTE, can the
join on a CTE use the index of the original table?, suppose two simple tables:
CREATE TABLE employee
(
emp_id integer NOT NULL,
name character varying NOT NULL,
CONSTRAINT employee_pkey PRIMARY KEY
El 25/10/11 18:43, Tom Lane escribió:
Linos i...@linos.es writes:
i am having any problems with performance of queries that uses CTE, can
the
join on a CTE use the index of the original table?
CTEs act as optimization fences. This is a feature, not a bug. Use
them when you want
I am searching what would be the best hardware combination to a new server i
have to install, the new server will have a Postgresql 9.0 with a database of
about 10gb, the database part it is not the problem for me, in this size almost,
the part where i am a bit lost is that i have to share from
El 06/02/11 20:05, Scott Marlowe escribió:
On Sun, Feb 6, 2011 at 11:16 AM, Linosi...@linos.es wrote:
I am searching what would be the best hardware combination to a new server i
have to install, the new server will have a Postgresql 9.0 with a database
of about 10gb, the database part it is
El 06/02/11 20:24, Pierre C escribió:
On Sun, 06 Feb 2011 19:16:23 +0100, Linos i...@linos.es wrote:
I am searching what would be the best hardware combination to a new server i
have to install, the new server will have a Postgresql 9.0 with a database of
about 10gb, the database part
Thanks for all the suggestions i will go with 8 10k disks, well 9 if you count
the spare now that i am scared :)
Regards,
Miguel Angel.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
Hello,
i have to buy a new server and in the budget i have (small) i have to select
one of this two options:
-4 sas 146gb 15k rpm raid10.
-8 sas 146gb 10k rpm raid10.
The server would not be only dedicated to postgresql but to be a file server,
the rest of options like plenty of ram and
Ross J. Reedstrom escribió:
Excellent. I'll take a look at this and report back here.
Ross
On Mon, Feb 23, 2009 at 04:17:00PM -0500, Tom Lane wrote:
Ross J. Reedstrom reeds...@rice.edu writes:
Summary: C client and large-object API python both send bits in
reasonable time, but I suspect
Tom Lane escribió:
Linos i...@linos.es writes:
Hello, i have been having a problem like this in debian machines and i have
discovered that (almost in my case), the problem only arises when i am using
ssl = true in postgresql.conf although i am using clear tcp connections to
localhost
Tom Lane escribió:
Linos i...@linos.es writes:
Tom Lane escribió:
Does that number include connection startup overhead? (If it doesn't,
it'd be pretty strange.)
This difference it is from the runtime of the query, i get this with \timing
parameter in psql,
That's just weird --- ssl off
Magnus Hagander escribió:
Tom Lane wrote:
Linos i...@linos.es writes:
Tom Lane escribió:
That's just weird --- ssl off should be ssl off no matter which knob you
use to turn it off. Are you sure it's really off in the slow connections?
Maybe i am missing something, i use the same command
19 matches
Mail list logo