Thanks for response, sir.
On 11/20/2016 1:18 AM, Tom Lane wrote:
Man Trieu writes:
As in the example below, i think the plan which hash table is created on
testtbl2 (the fewer tuples) should be choosen.
The planner usually prefers to hash on the table that has a flatter
MCV histogram, since
Thanks for reply, sir.
On 11/21/2016 1:39 AM, Tom Lane wrote:
Man writes:
Additional information.
In 9.6 the second table (lesser tuple) was choosen (the same testdata).
There are something (cost estimation?) different in previous versions.
I'd bet on different statistics in th
Can anybody explain why the search_path setting, with several config reloads,
would not change via local connections? We struggled with our production
settings on Postgres 9.3 today, only to realize, after a while, that the
search_path change actually took effect via TCP/IP, but not unix socket
resql.org
> Subject: Re: [GENERAL] search_path not reloaded via unix socket connections
> Date: Thu, 17 Sep 2015 22:29:04 -0400
>
> Kong Man writes:
> > Can anybody explain why the search_path setting, with several config
> > reloads, would not change via local co
il.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] search_path not reloaded via unix socket connections
> Date: Thu, 17 Sep 2015 22:29:04 -0400
>
> Kong Man writes:
> > Can anybody explain why the search_path setting, with several config
> > re
Hi Experts,
As in the example below, i think the plan which hash table is created on
testtbl2 (the fewer tuples) should be choosen.
Because creating of hash table should faster in testtbl2. But it did not.
I have tried to change the ordering of table by tuning parameter even if
using pg_hint_plan
Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite some
time now, but most of my experience is consuming database, and for the
current project we are without a proper DBA and they have to bear with me
and so I must seek advice.
I have a list of building and a queue and the user
Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite some
time now, but most of my experience is consuming database, and for the
current project we are without a proper DBA and they have to bear with me
and so I must seek advice.
I have a list of building and a queue and the user
and not one hour late
because the user will lose the bonus for one hour.
2010/6/8 Andy Colson
> On 6/8/2010 11:53 AM, uaca man wrote:
>
>> Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite
>> some time now, but most of my experience is consuming database, and
What do you mean? That is what I think I am trying to do. No?
2010/6/8 Vick Khera
> On Tue, Jun 8, 2010 at 12:53 PM, uaca man wrote:
> > Lets say for a 20 thousand users server, it may have at most 20 thousand
> > constructions started at the same time.
> >
> > To ac
ng beyond
comprehension of a human mind(al least for my mind) and that was when I had
the super idea, lest put the queue on the crontab!
Looks like we are going to cut off a few options of the game.
ps: do i top post or bottom post here?
2010/6/8 Peter Hunsberger
> On Tue, Jun 8, 2010 at
2010/6/8 Peter Hunsberger
> On Tue, Jun 8, 2010 at 1:26 PM, uaca man wrote:
> >> 2) Think of the front end as changing states as the user interacts
> >> with it, then figure out what queries need to be made to correspond to
> >> the changes in state. For example,
2010/6/8 Oliver Kohll - Mailing Lists
> On 8 Jun 2010, at 20:12, uaca man wrote:
>
> > 2) Think of the front end as changing states as the user interacts
> > with it, then figure out what queries need to be made to correspond to
> > the changes in state.
>
>
>
Hi,
In my current project we have unusual (at least for me) conditions for
relation db, namely:
* high write/read ratio (writes goes from bulk data updates/inserts (every
couple or minutes or so))
* loosing some recent part of data (last hour for example) is OK, it can be
easy restored
First vers
Hello all,
I am trying to do a SELECT operation with a WHERE condition. However, the
column with which I am trying to do the comparison has several values which
are pipe-delimited. I want to return a match(true) if the WHERE condition
matches any of the bar-delimited values.
For example, SELECT i
.
Arjen's solution(haven't tried yet) looks better to me.
-Neel
On Mon, Aug 23, 2010 at 5:59 PM, Arjen Nienhuis wrote:
> On Tue, Aug 24, 2010 at 12:44 AM, san man wrote:
>
>> Hello all,
>>
>> I am trying to do a SELECT operation with a WHERE condition. Howe
I upgrade postgresql from 8.4.2 to 9.0.4.
But I have one problem.
The Error message 'cannot execute nextval() in a read-only transaction'
Please help me.
[Version 8.4.2]
DEVDB=# select version();
version
-
17 matches
Mail list logo
