Ivan Voras wrote:
On 28/02/2012 17:57, mgo...@isstrucksoftware.net wrote:
Our application runs on Windows, however we have been told that we can
pick any OS to run our server on. I'm thinking Linux because from
everything I've read, it appears to be a better on performance and there
are other f
Nick wrote:
I have a pretty well tuned setup, with appropriate indexes and 16GB of
available RAM. Should this be taking this long? I forced it to not use
a sequential scan and that only knocked a second off the plan.
QUERY
PLAN
---
salah jubeh wrote:
Hello Guys,
In the past I had a view defined as follows
CREATE view abcd as
SELECT whatever .. --- query1
Some business requierments came up and I had to change it like this
CREATE view abcd as
SELECT whatever .. --- query1
UNION
SELECT whatever .. query2
Tom Lane wrote:
Volodymyr Kostyrko writes:
Maybe I'm missing something but I have found a case when planner is
unoptimal.
The planner knows next to nothing about optimizing FULL JOIN, and
I would not recommend holding your breath waiting for it to get better
about that, because th
Hi all.
Maybe I'm missing something but I have found a case when planner is
unoptimal.
# Creating table
create table test_stat(id smallint, count smallint, date date);
# Filling table, sorry for php
$insert = $db->prepare('insert into test_stat (id, count, date) values
(?, 1, to_timestamp(?
