-04-15'
[..]
Redoing the SQL with fix date (date = '2009-04-01') o cost in explain always
still about 200 or less. But with a period the cost is high, about 6000 or
more.
Select is using Index and the date is using index too.
There is some way to use date period with less cost?
Rafael Domiciano
Hello Grzegorz,
Thnks for response, but lot of the selects is using BETWEEN and the cost is
the same.
2009/4/20 Grzegorz Jaśkiewicz
> BETWEEN X AND Y
>
> On Mon, Apr 20, 2009 at 2:55 PM, Rafael Domiciano
> wrote:
> > Hello People,
> >
> > I have initiated a
Hello all you guys,
Since saturday I'm get stucked in a very strange situation: from time to
time (sometimes with intervals less than 10 minutes), the server get
"stucked"/"hang" (I dont know how to call it) and every connections on
postgres (dont matter if it's SELECT, UPDATE, DELETE, INSERT, sta
thing related to "LwLocks", as I did
some googling and found some related problems and slides. There is some way
I can confirm this?
4) Rebooting the server didn't make any difference.
Appreciate any help,
Rafael
On Tue, Jun 11, 2013 at 9:48 AM, Rafael Domiciano <
rafael.domi
