Reducing worker mem shaved about 12 minutes off the query time.. Thanks for the
suggestion. I lowered it to 10MB instead of 100MB
> On Dec 29, 2016, at 8:07 PM, Charles Clavadetscher
> wrote:
>
> Forwarding to list.
>
> -Original Message-
> From: ajm
I am trying to optimize and tune my server for fastest simple queries with
highest connection to server possible. Basically, a SELECT item from table
takes 30 minutes on a machine with SSD drives. The table has 900K entries
and 12 columns. Using that SELECT query, I then have the ability to make
a
unsubscribe
On Sat, Mar 30, 2013 at 9:07 PM, Adrian Klaver wrote:
> On 03/30/2013 08:42 PM, ajmcello wrote:
>
>> unsubscribe
>>
>>
> If you want to unsubscribe:
>
>
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-gen
unsubscribe
On Sun, Mar 31, 2013 at 3:31 AM, Gavan Schneider wrote:
> On 30/3/13 at 11:09 PM, D'Arcy J.M. Cain wrote:
>
> I am formulating Cain's Law. Something like "If a discussion lasts
>> long enough, someone will mention Godwin's Law."
>>
>
> +1
>
> More formally:
> As an online disc
unsubscribe
On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov wrote:
> Hello colleagues !
>
> I have to write pl/pgsql function that has to be triggered not
> before/after insert, but in definite time. Does postgresql allows to do
> this ?
>
> Thanks a lot.
>
> --
> Best regards,
> Sincerely your
unsubscribe
On Wed, Mar 27, 2013 at 3:12 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> In contrast to certain other open-source databases, PostgreSQL leans
> toward protecting data from surprises and erroneous input, i.e. rejecting a
> date of 2013-02-31 instead of arbitrarily as
unsubscribe
On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov wrote:
> Hello colleagues !
>
> I have to write pl/pgsql function that has to be triggered not
> before/after insert, but in definite time. Does postgresql allows to do
> this ?
>
> Thanks a lot.
>
> --
> Best regards,
> Sincerely your
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] On Behalf Of ajmcello
>> Sent: Monday, July 02, 2012 7:23 PM
>> To: pgsql-general@postgresql.org
>> Subject: [GENERAL] Query ordering question
>>
>> I'm interested in sorting my
I'm interested in sorting my query by time descending, with the
highest percent by latest time shown first, and then every other
record associated with column name sorted by time descending,
following the first record. Does that make sense?
The first query is the best I've come up with. The second
