Thank you for all your suggestions and I hope the "set enable_seqscan = off;"
will work for the time being until we can make PG config changes and more
testing in the near future. We expect indeed much better performance with index
being used on the 33+million rows table vs seq scan and I will p
Greg Stark wrote:
> On Thu, Mar 31, 2011 at 11:33 PM, Kevin Grittner
> wrote:
>> Greg Stark wrote:
>>
>>> your query does require reading all the data.
>>
>> Huh? It requires reading all the data from at least *one* of the
>> tables.
>
> The query he posted a plan for was:
>
> EXPLAIN ANALYZE
On 4/1/2011 1:34 AM, DI Martin Handsteiner wrote:
Here a working test case:
Properties properties = new Properties();
properties.setProperty("user", "sa");
properties.setProperty("password", "");
properties.put("shutdown", Boolean.
The following bug has been logged online:
Bug reference: 5962
Logged by: Sumit
Email address: sam141...@gmail.com
PostgreSQL version: 8.3
Operating system: win 7
Description:Problem Acessing Network Path
Details:
I am trying to use lo_import('//user-xyz/abc.txt')
t
On 03/31/11 6:50 PM, Raphael Giovanini wrote:
I`m change the default passwod, and not conect for this user. What the
default password?
there is no default password. on most unix and linux distributions, the
default authentication mode is set to 'ident' which means a given unix
user X can onl
I`m change the default passwod, and not conect for this user. What the
default password?
Raphael Giovanini
+55-11-9938-6810
"O que pensais, passais a ser" (Gandhi)
