The following bug has been logged online:
Bug reference: 3223
Logged by: Stefan Kaltenbrunner
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.8
Operating system: FreeBSD 6.2STABLE
Description:Testbugreport for new wwwmaster
Details:
testing the bugreport fo
The following bug has been logged online:
Bug reference: 3225
Logged by: Jens-Wolfhard Schicke
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Linux
Description:BitmapOr plan node does not show currect row count
Details:
I an explain analy
The following bug has been logged online:
Bug reference: 3224
Logged by: Gabriele Bartolini
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: GNU/Linux ( 2.6.9-42.0.2.ELsmp )
Description:Dump: missing schema name for sequence in a "DEFAULT
n
Jens-Wolfhard Schicke wrote:
I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
looked like this:
BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
rows=0 loops=1)
Yet, the last subnode was:
Bitmap Index Scan on location_gs (cost=0.00..8.14 row
"Jens-Wolfhard Schicke" <[EMAIL PROTECTED]> writes:
> I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
> looked like this:
> BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
> rows=0 loops=1)
BitmapOr and BitmapAnd don't attempt to count their re
"Gabriele Bartolini" <[EMAIL PROTECTED]> writes:
> However, when I issue a pg_dump or pg_dumpall command, here is what I get:
> SET search_path = dimensions, pg_catalog;
> CREATE SEQUENCE hosts_2006_seq;
> CREATE TABLE hosts_2006 (
> id_host integer DEFAULT nextval('hosts_2006_seq'::regclass)
Tom Lane wrote:
"Jens-Wolfhard Schicke" <[EMAIL PROTECTED]> writes:
I an explain analyze I saw recently, a BitmapOr node of 5 Bitmap Index Scan
looked like this:
BitmapOr (cost=43.57..43.57 rows=1833 width=0) (actual time=0.146..0.146
rows=0 loops=1)
Can we do better than just sayi
Hi,
The user in pg_stat_activity does not change when use the 'set session
authorization' command. So we couldn't track the real user. Is it a bug
or a feature?
regression=# select usesysid,usename,datname from pg_stat_activity;
usesysid | usename | datname
--+--+---
