On Wed, Nov 3, 2010 at 1:04 PM, Gabriel Dinis <
gabriel.di...@vigiesolutions.com> wrote:
> Dear all,
>
> Imagine I have two users "Maria" and "Ana" using a PHP site.
> There is a common Postgres user "phpuser" for both.
> I'm creating audit tables to track the actions made by each PHP site user.
>
On Thu, Oct 21, 2010 at 8:51 PM, DM wrote:
> Why is the difference in query plan, and the total runtime. Both tables have
> the same btree index
>
>
> test=# explain analyze select * from test_seqindex1 where sid='AA023';
> QUERY
> PLAN
On Thu, Oct 21, 2010 at 3:47 AM, DM wrote:
> I was hoping the optimizer would do a join using index scan.
>
> Could some one please explain me why its not doing an index scan rather than
> sequential scan .
A index scan would be probably slower here because you're asking for a
lot of rows. A lot
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
> On 06/10/2010 14:26, Georgi Ivanov wrote:
>>
>> Hi,
>> I have some issue where
>> SELECT * from pg_stat_activity WHERE current_query='';
>> returns too many rows .
>> Any ideas why is this happening ?
>
> Are you using any kind of connecti
On 28/06/10 17:22, Neubert Joachim wrote:
I want to convert accented characters to the according base character,
e.g. "Ü" or "Ú" to "U".
I have the following:
CREATE OR REPLACE FUNCTION unaccent(TEXT) RETURNS TEXT AS
$$
use Text::Unaccent;
return unac_string('UTF8', $_[0]);
$$ LANGU
On Wed, Jun 2, 2010 at 7:44 PM, Adrian von Bidder wrote:
> On Monday 31 May 2010 10.29:22 Michal Szymanski wrote:
>> for Debian sometimes we had to wait many weeks for
>> official packages.
>
> Experiemntal packages can be installed directly into Debian unstable (sid)
> installations and can often
On Sun, Jan 17, 2010 at 8:06 PM, Jeff Davis wrote:
> On Sat, 2010-01-16 at 19:02 +0100, Mathieu De Zutter wrote:
>> Hi,
>>
>> I'm trying to make constraint exclusion work correctly in a query with
>> only one parameter, but I have some issues.
>> Please have
On Sat, Jan 16, 2010 at 7:26 PM, Scott Marlowe wrote:
> On Sat, Jan 16, 2010 at 11:02 AM, Mathieu De Zutter
> wrote:
>> shs-dev=# explain select * from parent where (c,n) = '("b",0)';
>> ERROR: input of anonymous composite types is not implemented
>
Hi,
I'm trying to make constraint exclusion work correctly in a query with
only one parameter, but I have some issues.
Please have a look at the scenario below and tell me how I can improve it.
Thanks!
-- I create an inheritance relationship with a check constraint in the child
shs-dev=# creat
