Ben <[EMAIL PROTECTED]> writes:
> music=# explain ... where ... playlist.stream=1
> -> Seq Scan on playlist (cost=0.00..300.81 rows=2321 width=20)
> music=# explain ... where ... playlist.stream=2
> -> Seq Scan on playlist (cost=0.00..300.81 rows=205 width=20)
I am betting that 1 is
I think this is a question regarding the backend, but...
I'm in the process of changing 1 large table (column wise) into 6 smaller
tables, and ran into a situation. I'm using Postgresql 7.1beta5, Pg as
included, Perl 5.6, Solaris 2.6 on an Ultra 5.
The new setup is 6 tables, the 'main' table l
SELECT FOR UPDATE should work. Did you use it in a transaction? For example:
Session 1:
CREATE TABLE accounts (amount float8);
INSERT INTO accounts VALUES (10);
BEGIN;
SELECT * FROM accounts FOR UPDATE;
Session 2:
BEGIN;
SELECT * FROM accounts FOR UPDATE; < This should block
Session 1:
U
I've never used the locking features of Postgres before, and now I
find that I need to use them. I read through the instructions, but
I've never taken a database theory course so I don't understand all
the terms they used.
Here's what I need to do: The database keeps accounts. If one process
i
I think that's because the stream=1 query is doing a sequential scan on
files, so it has to look at everything, whereas the index scan in the
stream=2 query only looks at the important rows. (Which in this case was
just 1 row.)
I think this question is: why is one using an index scan and the oth
Hmm, I also notice that it's getting very different numbers for
rows from files as well.
On Fri, 9 Mar 2001, Ben wrote:
> Every night. There are 6223 rows with stream=2 and 7041 rows with
> stream=1. At any given time, there will be between 1 to 30 rows with
> played=null for both values.
>
>
Hi guys,
I've put encode/decode functions (pg_bf-1.0.tar.gz) for Postgres
on my web-site for those who might need them
http://boulat.net/pub
Regards,
Boulat Khakimov
--
Nothing Like the Sun
---(end of broadcast)---
TIP 1: subscribe and unsubsc
Every night. There are 6223 rows with stream=2 and 7041 rows with
stream=1. At any given time, there will be between 1 to 30 rows with
played=null for both values.
On Fri, 9 Mar 2001, Stephan Szabo wrote:
>
> Has vacuum analyze been run on both recently? What is the maximum number
> of rows wi
Has vacuum analyze been run on both recently? What is the maximum number
of rows with a particular stream value, and how many does each of 1 and 2
actually have?
> Interestingly, the sequential scan on playlist claims to be returning 2000
> results for stream=1 and only 200 for stream=2. I'm no
We have two postgres-driven web pages, and we've noticed in the last few
days that one is loading about 10 times faster than the other. Looking
into it, we found out that postgres has very different execution paths for
what is essentially the same query, and this makes no sense to me.
Sorry for t
On Fri, 9 Mar 2001, Nico wrote:
> What is wrong?
>
> CREATE FUNCTION set_value(text) RETURNS OPAQUE AS '
> DECLARE
> val ALIAS FOR $1;
> BEGIN
> NEW.inf := val;
> RETURN NEW;
> END;
> ' LANGUAGE 'plpgsql';
>
>
> CREATE TABLE t1 (
> id serial,
> inf
Yes, it's currently not implemented (see other currently
running thread in pgsql-general about this topic)
On Fri, 9 Mar 2001 [EMAIL PROTECTED] wrote:
> Hello,
>
> We have the following schema :
> create table A (id_A integer primary key,b_A integer);
> create table B (a_B integer) inherits A;
On Fri, 9 Mar 2001, Einar Karttunen wrote:
> On Wed, 7 Mar 2001, Stephan Szabo wrote:
> >
> > You cannot safely reference tops of inheritance trees under 7.0 or 7.1 and
> > have it reference the trees.
> >
> Is there anyway to emulate this? I want to have several types of persons
Someone's been
Nico <[EMAIL PROTECTED]> writes:
> What is wrong?
[...]
> CREATE TRIGGER t1_set_val BEFORE INSERT ON t1
> FOR EACH ROW EXECUTE PROCEDURE set_value('some info');
Trigger functions can't take arguments.
-Doug
---(end of broadcast)---
TIP 4: Don
On Fri, Mar 09, 2001 at 03:43:55PM -0300, Marcelo Pereira wrote:
>
>Hi,
>
>
>
>I'm a new user and I would like to know if I can create my table using
>forein key's.
Sure. Here's an example:
test=> CREATE TABLE statename ( code CHAR(2) PRIMARY KEY,
test(>
That search feature regularly breaks. That's about all I can say.
[ Charset ISO-8859-1 unsupported, converting... ]
> I apologise if this has been posted/asked already, but since it has been
> about a week and it hasn't been "fixed" I needed to ask. Every time I
> issue a search at htt
Hi,
I'm a new user and I would like to know if I can
create my table using forein key's.
Thanks
Marcelo Pereira
Computer Programmer
What is wrong?
CREATE FUNCTION set_value(text) RETURNS OPAQUE AS '
DECLARE
val ALIAS FOR $1;
BEGIN
NEW.inf := val;
RETURN NEW;
END;
' LANGUAGE 'plpgsql';
CREATE TABLE t1 (
id serial,
info text
);
CREATE TRIGGER t1_set_val BEFORE INSER
I apologise if this has been posted/asked already, but since it has been
about a week and it hasn't been "fixed" I needed to ask. Every time I
issue a search at http://www.postgresql.org/search.mpl even on the
easiest of search items, such as "postgres" I get a result of this, and
onl
> What's the difference between PoPy and the PygreSQL driver
> included in
> the PostgreSQL distribution? Just curious.
Several things actually. PyGreSQL is a C module and two Python
script files, while PoPy is built entirely as a C module which
should mean more speed. PoPy is Python DB API 2.
"Brent R. Matzelle" wrote:
>
> > > I use PoPy and think it's dandy. I also thought it *was* the
> > DB API 2.0--
> > > am I mistaken here?
>
> I noticed a couple posts asking for PoPy RPMs so I created some and posted
> them below if anyone is interested.
What's the difference between PoPy and
Daniel J. Kressin writes:
> I know that you can make table names case-sensitive by putting them in
> quotes. Is there a way (compile-time option, anything?) to make them
> case-sensitive by default (i.e. without quotes)?
No. You need to write to the SQL standards committee if you want to
chang
Peter Eisentraut wrote:
>
> Daniel J. Kressin writes:
>
> > I know that you can make table names case-sensitive by putting them
> > in quotes. Is there a way (compile-time option, anything?) to make
> > them case-sensitive by default (i.e. without quotes)?
>
> No. You need to write to the S
Hello,
We have the following schema :
create table A (id_A integer primary key,b_A integer);
create table B (a_B integer) inherits A;
create table C (id_C integer primary key, b_C integer);
create table D (id1 integer references A (id_A),
id2 integer references C (id_C),
> > I use PoPy and think it's dandy. I also thought it *was* the
> DB API 2.0--
> > am I mistaken here?
I noticed a couple posts asking for PoPy RPMs so I created some and posted
them below if anyone is interested.
http://www.linuxshare.com/popy/
Brent
---(end of broa
Hi,
I have an application that receives data with attributes concatenated as
a string seperated by a /
I use perl code to split it into seperate attributes and store it from
one table into another (Solid database)
What I would like to do is:
- Receive the data in a table that stores the canca
26 matches
Mail list logo
