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, Linos 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 not the
El 06/02/11 20:24, Pierre C escribió:
On Sun, 06 Feb 2011 19:16:23 +0100, Linos 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 not the problem
ah ok, i was not sure about this point, thanks.
Regards,
Miguel Angel
El 06/02/11 21:38, Andy escribió:
--- On Sun, 2/6/11, Linos wrote:
I am studying too the possibility of use an OCZ Vertex 2
Pro with Flashcache or Bcache to use it like a second level
filesystem cache, any comments on
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" writes:
Summary: C client and large-object API python both send bits in
reasonable time, but I suspect there's still room
Tom Lane escribió:
Linos 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 to perfor
Tom Lane escribió:
Linos 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 of
Magnus Hagander escribió:
Tom Lane wrote:
Linos 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 to
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 batt
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:
http://www.postgresql.org/mailpref/pgsql-pe
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 (emp_i
El 25/10/11 18:43, Tom Lane escribió:
> Linos 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.
El 25/10/11 19:11, Merlin Moncure escribió:
> On Tue, Oct 25, 2011 at 11:47 AM, Linos wrote:
>> El 25/10/11 18:43, Tom Lane escribió:
>>> Linos writes:
>>>> i am having any problems with performance of queries that uses CTE,
>>>> can the
>&g
El 26/10/11 14:23, Merlin Moncure escribió:
> On Wed, Oct 26, 2011 at 4:00 AM, Linos wrote:
>> El 25/10/11 19:11, Merlin Moncure escribió:
>>> On Tue, Oct 25, 2011 at 11:47 AM, Linos wrote:
>>>> El 25/10/11 18:43, Tom Lane escribió:
>>>>> Linos wri
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. I
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 tha
On 04/06/14 21:36, Merlin Moncure wrote:
> On Wed, Jun 4, 2014 at 8:56 AM, Linos 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
>> paste
On 04/06/14 22:57, Merlin Moncure wrote:
> On Wed, Jun 4, 2014 at 2:58 PM, Linos wrote:
>> On 04/06/14 21:36, Merlin Moncure wrote:
>>> On Wed, Jun 4, 2014 at 8:56 AM, Linos wrote:
>>>> Hello,
>>>>
>>>> Some days ago I upgraded from 8.
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
>>
20 matches
Mail list logo
