Tomas Lanczos wrote:
I am using Postgresql to store all my research related data. At the
moment I am just finishing my PhD thesis and I want to cite postgresql
correctly but can't find how to do it. Could somebody give me an advice?
I'm not sure if the citation list is the right thing for
Webb Sprague wrote:
Hi all,
(Version 3.5.5)
I'd upgrade - version 3.5.5 doesn't actually exist :-)
I have tried to figure this out, but the docs, google, and my all
imagination fail me. I want to use a join clause with a using list
in an update statement. The following works, but it uses
Hi,
I'm trying to use lesslog 1.1 (out of NTT rpm available on pgfoundry) on my
pg_xlog files out of a 8.3.3 postgresql server.
I always get messages such as incorrect resource manager data checksum.
This message is issued (as I've read the sources) when there's CRC mismatch
in a record.
Do you
Hi all
I've been forced into a project that uses MS Access with PostgreSQL.
This message is intended as a bit of a warning to others who actually
have a choice about it, as there are some issues you may not be aware of
that might sway your decision to use Access in a new project instead of
Hi all,
I developed a little tool in Java that updates databases throught text
files.
In this tool there is an option that allows the user accepts a defined
amount of errors and save the well formed data.
To do this I start commitment control when the process begins and, at the
end, if the
Hi all,
I developed a little tool in Java that updates databases throught text
files.
In this tool there is an option that allows the user accepts a defined
amount of errors and save the well formed data.
To do this I start commitment control when the process begins and, at the
end, if the
Flavio Palumbo, 18.11.2008 10:01:
I tested this tool under MySql and Oracle and everything went as expected.
Unfortunately postgres seems to work in a different way, cause if there is
just one error while the transaction is active I'm not able to commit the
well formed data in the db, no matter
Flavio Palumbo wrote:
Unfortunately postgres seems to work in a different way, cause if there is
just one error while the transaction is active I'm not able to commit the
well formed data in the db, no matter if the good records were inserted
sooner or later the error.
Does this behavior
Craig Ringer wrote:
Hi all
I've been forced into a project that uses MS Access with PostgreSQL.
[snip]
The big issue is with Access's linked table support via ODBC (at least
as of Access 2007). Unlike tools like Hibernate, which are capable of
executing filters, queries across multiple
On Thu, 13 Nov 2008 09:11:05 -0500
Tom Lane [EMAIL PROTECTED] wrote:
Teodor Sigaev [EMAIL PROTECTED] writes:
Yeah, I'm not convinced either. Still, Teodor's theory should
be easily testable: set synchronize_seqscans to FALSE and see
if the problem goes away.
Test suit to reproduce the
Craig Ringer wrote:
If I reduce maintenance_work_mem
then the database dump/restore is slower but there is less overall
impact on the server.
There could be more impact, rather than less, if it forces a sort that'd
be done in memory out to disk instead. If you have dedicated storage on
Flavio Palumbo wrote:
I developed a little tool in Java that updates databases throught text
files.
In this tool there is an option that allows the user accepts a defined
amount of errors and save the well formed data.
To do this I start commitment control when the process begins
and,
On Mon, Nov 17, 2008 at 09:56:51PM +0100, Tomas Lanczos wrote:
I meant something for use in publications, like it is used for R and
almost identically for GRASS:
R Development Core Team (2008). R: A language and environment for
statistical computing. R Foundation for Statistical
On Mon, Nov 17, 2008 at 11:22:47AM -0800, Lothar Behrens wrote:
I have a problem to find as fast as possible files that are double or
in other words, identical.
Also identifying those files that are not identical.
I'd probably just take a simple Unix command line approach, something
like:
On Tue, Nov 18, 2008 at 12:36:42PM +, Sam Mason wrote:
On Mon, Nov 17, 2008 at 11:22:47AM -0800, Lothar Behrens wrote:
I have a problem to find as fast as possible files that are double or
in other words, identical.
Also identifying those files that are not identical.
I'd probably
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 68719476736
Try bumping shmmni:
$ sysctl -d
Hello Bill,
I have this one set to 512 in loader.conf
other params in loader.conf:
kern.ipc.semmni=1024
kern.ipc.semmns=1024
kern.ipc.semmnu=512
Kind regards,
Christiaan Willemsen
Bill Moran wrote:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
People of world, help help please.
I created a DB with super-user postgres, I give all privileges to DB
(banco is my DB)
GRANT ALL ON DATABASE banco TO PUBLIC;
GRANT CREATE ON DATABASE banco TO PUBLIC
But other users can't create tables in this DB
ERROR:
banco= create table tabla (x
Flavio Palumbo wrote:
Unfortunately postgres seems to work in a different way, cause if there is
just one error while the transaction is active I'm not able to commit the
well formed data in the db, no matter if the good records were inserted
sooner or later the error.
Yes, that's right. As
am Tue, dem 18.11.2008, um 11:25:16 -0300 mailte Gustavo Rosso folgendes:
People of world, help help please.
I created a DB with super-user postgres, I give all privileges to DB
(banco is my DB)
GRANT ALL ON DATABASE banco TO PUBLIC;
GRANT CREATE ON DATABASE banco TO PUBLIC
But other
On Tue, Nov 18, 2008 at 1:25 PM, Craig Ringer
[EMAIL PROTECTED]wrote:
You can use savepoints (see the manual) to recover from errors, though
they have some issues if you use hundreds of thousands of savepoints in
a single transaction. It's much better to check the data on INSERT to
make
Andreas, my version is:
select version();
PostgreSQL 7.4 informix1.8 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
Is it old version?
Can to be the reason for my problem?
A. Kretschmer escribió:
am Tue, dem 18.11.2008, um 11:25:16 -0300 mailte
Hi group,
Considering following (simplified) example:
CREATE TABLE tblnr1(
nr1id SERIAL PRIMARY KEY,
firstname TEXT
);
CREATE TABLE tblnr2(
nr2id SERIAL PRIMARY KEY,
nr1id INTEGER REFERENCES tblnr1(nr1id)
);
CREATE TABLE tblnr3(
nr3id SERIAL PRIMARY KEY,
nr2id INTEGER REFERENCES
Hi all,
I'm a newbie to Postgres so please bear with me. I have a schema that
uses inherited tables. I need the queries on my 'event' table to always
be in descending order of the primary key, i.e. scan the index backwards
(for obvious performance reasons). Somehow the ORDER BY doesn't seem to
be
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
CREATE TABLE tblnr1(
nr1id SERIAL PRIMARY KEY,
firstname TEXT
);
CREATE TABLE tblnr2(
nr2id SERIAL PRIMARY KEY,
nr1id INTEGER REFERENCES tblnr1(nr1id)
);
CREATE TABLE tblnr3(
nr3id SERIAL
On Tue, Nov 18, 2008 at 11:46:07AM -0300,
Gustavo Rosso [EMAIL PROTECTED] wrote
a message of 68 lines which said:
PostgreSQL 7.4 informix1.8 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
Is it old version?
It is still in Debian stable
hello,
on restoring dumps I get errors about languages and functions not
getting restored:
pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 135; 1255 164
39 FUNCTION pldbg_step_over(integer) postgres
pg_restore: [Archivierer (DB)] could not execute query: FEHLER: Funktion
A lot of important information is missing in your post, for example:
a) Was the table analyzed recently? Is the table vacuumed regularly?
b) How large are the tables? (Number of tuples and pages. SELECT
reltuples, relpages FROM pg_class WHERE relname LIKE 'event%')
c) What values are used for the
Erwin Moller, 18.11.2008 15:47:
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables that
have FK constraints on that table (tblnr1)
That could be resolved with a query against the INFORMATION_SCHEMA
Something like
SELECT c.table_name
ries van Twisk schreef:
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
CREATE TABLE tblnr1(
nr1id SERIAL PRIMARY KEY,
firstname TEXT
);
CREATE TABLE tblnr2(
nr2id SERIAL PRIMARY KEY,
nr1id INTEGER REFERENCES tblnr1(nr1id)
);
CREATE
Hi Thomas,
I wrote the following test case that seems to work fine.
Any suggestion ?
Thanks a lot
Flavio
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Savepoint;
public class TestCommitPostgres {
public TestCommitPostgres() {
Bill Moran [EMAIL PROTECTED] writes:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 68719476736
Hi Tom,
Tom Lane wrote:
I'm wondering about the shmall setting myself. The Postgres docs
suggest that FreeBSD measures shmall in pages. If so, the above
setting is far too large and is perhaps resulting in an internal
overflow in the kernel.
Hmm, might be.. I can try lowering the value,
A. Kretschmer [EMAIL PROTECTED] writes:
am Tue, dem 18.11.2008, um 11:25:16 -0300 mailte Gustavo Rosso folgendes:
banco= create table tabla (x integer);
NOTICE: CREATE TABLE / UNIQUE will create implicit index
tabla_oid_idx for table tabla
*ERROR: must be owner of relation tabla*
Thomas Kellerer schreef:
Erwin Moller, 18.11.2008 15:47:
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables that
have FK constraints on that table (tblnr1)
That could be resolved with a query against the INFORMATION_SCHEMA
Something
We have an instance of PostgreSQL on Windows 2003 with some application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a solution with standby.
Is there a product of High Availability for PostgreSQL
Harald Armin Massa [EMAIL PROTECTED] writes:
Is there a clever way to exclude them from dumps or restores?
You're thinking about it backwards. The correct way to deal with this
is to create the destination database for the restore from template0,
so that it doesn't have any of template1's
Hi,
if I got it right the reason some aggregates (such as COUNT) using only index
columns are slow on postgresql is that it uses MVCC, so it has to read the
data as well as the index. It makes sense to me, but I don't understand is how
other databases (such as Oracle) do it.
Can someone
Christiaan Willemsen wrote:
Bill Moran wrote:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax:
Hello Shane,
All settings are as expected by both sysctl.conf and loader.conf
Shane Ambler wrote:
Christiaan Willemsen wrote:
Bill Moran wrote:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
Index all the columns used in the join conditions e.g.
a.user_id=b.user_id
need unique indexes on both
a.user_id
b.user_id
(default is to FTS which will slow your query to a crawl)
HTH
Martin
__
Disclaimer and confidentiality note
Everything in
Albe Laurenz wrote:
Tomas Lanczos wrote:
I am using Postgresql to store all my research related data. At the
moment I am just finishing my PhD thesis and I want to cite postgresql
correctly but can't find how to do it. Could somebody give me an advice?
I'm not sure if the citation list
ries van Twisk wrote:
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
snip
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables that
have FK constraints on that table (tblnr1)
Hi,
I've just started using PostgreSQL and have been reading up on it.
Part of what I wanted to do was to have a column which automatically
incremented itself by one every time I do an INSERT. From reading the
manual I was lead to believe that the correct type for this was either
serial
On 18 nov 2008, at 17.09, Pietro Tedesco
[EMAIL PROTECTED] wrote:
We have an instance of PostgreSQL on Windows 2003 with some
application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a
On Tue, Nov 18, 2008 at 10:24 AM, Simon Connah
[EMAIL PROTECTED] wrote:
Hi,
I've just started using PostgreSQL and have been reading up on it. Part of
what I wanted to do was to have a column which automatically incremented
itself by one every time I do an INSERT. From reading the manual I was
Table contains CHAR(20) type columns containing numbers and other values.
I need to obtain max integer considering only numbers from start of column
up to first non-integer character.
I tried
create temp table test (test char(20));
insert into test values ('12');
insert into test values
On 18/11/2008 17:37, Scott Marlowe wrote:
create table a (i int primary key, info text);
create sequence a_i_seq;
alter table a alter column i set default nextval('a_i_seq');
You'll also need to grant SELECT and UPDATE permissions on the sequence
to the user that'll be INSERTing into the
Thank you Tomas for the reply.
I'm including the requested information below. To sumarize my problem:
The same query with order by desc on 2 tables (concrete and abstract).
A backward PK index scan is used when run on the concrete table, but not
when run on the abstract table.
a) Was the table
There are a couple of solutions probably.
First off, search pgfoundry for possibilities, look into clustering and
replication.
A little more insight would make it easier to answer your question:
Determine what you exactly want, what kind of uptime at what expense.
How should it be made available
There are a couple of solutions probably.
First off, search pgfoundry for possibilities, look into clustering and
replication.
A little more insight would make it easier to answer your question:
Determine what you exactly want, what kind of uptime at what expense.
How should it be made available
On Tue, Nov 18, 2008 at 04:49:35PM +, Scara Maccai wrote:
if I got it right the reason some aggregates (such as COUNT) using
only index columns are slow on postgresql is that it uses MVCC, so
it has to read the data as well as the index.
Every aggregate (of which COUNT is just one example)
On Tue, Nov 18, 2008 at 1:10 AM, Craig Ringer
[EMAIL PROTECTED] wrote:
I've been forced into a project that uses MS Access with PostgreSQL.
This message is intended as a bit of a warning to others who actually
have a choice about it, as there are some issues you may not be aware of
that might
On 18 Nov 2008, at 17:40, Raymond O'Donnell wrote:
On 18/11/2008 17:37, Scott Marlowe wrote:
create table a (i int primary key, info text);
create sequence a_i_seq;
alter table a alter column i set default nextval('a_i_seq');
You'll also need to grant SELECT and UPDATE permissions on the
On 18/11/2008 17:33, Andrus wrote:
create temp table test (test char(20));
insert into test values ('12');
insert into test values ('23/3');
insert into test values ('AX/3');
select max(test::int) from test;
but got
ERROR: invalid input syntax for integer: 23/3
How to fix
On Tue, Nov 18, 2008 at 07:33:47PM +0200, Andrus wrote:
I need to obtain max integer considering only numbers from start of column
up to first non-integer character.
I tried
create temp table test (test char(20));
insert into test values ('12');
insert into test values ('23/3');
insert
On Tue, Nov 18, 2008 at 05:51:08PM +, Raymond O'Donnell wrote:
You could use a regular expression in substring() to get just the
numeric bits.
Thanks, never noticed that substring would accept a regexp before.
Syntax is a bit baroque, but it seems to work!
Sam
--
Sent via
Shane Ambler schreef:
ries van Twisk wrote:
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
snip
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables
that have FK constraints
Raymond,
You could use a regular expression in substring() to get just the
numeric bits.
Thank you.
I do'nt have any experience on regex.
Can you provide a sample how to use regex to get numeric substring from
start of string ?
Andrus.
--
Sent via pgsql-general mailing list
Right, passthrough queries is the answer. I once had to build an Access
front end to a very large Oracle database for a client. As you discovered,
directAccess queries can be extermely slow and large. With a passthrough,
all the real work is done on the host database and just the result you want
Hello
I used this code
CREATE OR REPLACE FUNCTION list_user_tables_sort_depend
(owner VARCHAR, revers BOOLEAN) RETURNS SETOF VARCHAR AS '
DECLARE tabulky VARCHAR[]; i INTEGER; opakovat BOOLEAN = ''t'';
pom VARCHAR; exportovano VARCHAR[] = ''{}''; r RECORD;
mohu_exportovat BOOLEAN;
BEGIN
Christiaan Willemsen [EMAIL PROTECTED] writes:
Tom Lane wrote:
I'm wondering about the shmall setting myself. The Postgres docs
suggest that FreeBSD measures shmall in pages. If so, the above
setting is far too large and is perhaps resulting in an internal
overflow in the kernel.
Hmm,
I am looking to convert all my database access code into stored
procedures in PL/PGSQL.
I have googled but it looks like there's a whole variety of
information from 2003 (when PG must have been quite different) until
now--some people find stored functions slow for web based apps, others
find it
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, Nov 18, 2008 at 10:24 AM, Simon Connah
[EMAIL PROTECTED] wrote:
But whenever I try and update my column to this type it says that it can not
find that data type. Am I doing something wrong?
Serial is a pseudotype.
Perhaps better to say it's a
DANG Trieu [EMAIL PROTECTED] writes:
On the abstract table (event):
gsmlog3_30=# explain analyze select * from event where timestamp
1226952050683 order by timestamp desc limit 10;
Turning on constraint exclusion might help here, if you have appropriate
check constraints for the range of
Sam Mason [EMAIL PROTECTED] writes:
On Tue, Nov 18, 2008 at 04:49:35PM +, Scara Maccai wrote:
It makes sense to me,
but I don't understand is how other databases (such as Oracle) do it.
I believe Oracle maintains a separate log (not sure how it's structured)
that contains this
On Wed, 2008-11-19 at 02:18 +0800, Phoenix Kiula wrote:
I am looking to convert all my database access code into stored
procedures in PL/PGSQL.
But a DBA told me that it will be much better to do all of these
things in a stored procedure as it may bring some performance
benefits. He's an
FWIW, I believe that count(*) is pretty slow in Oracle too.
Well COUNT was only an example. I think (but I'm not sure AT ALL) that
SELECT A FROM myTAB where A 1
only uses the index (if there's an index defined for A) in Oracle.
But mine was just curiosity... which I think you and Sam
On Tue, Nov 18, 2008 at 12:48 PM, Sam Mason [EMAIL PROTECTED] wrote:
It makes sense to me,
but I don't understand is how other databases (such as Oracle) do it.
There are tradeoffs in both directions; [...] but Oracle's way is more
optimized
response type=snarky
For the most part, that's
Hello,
I'm working with Pg 7.4 on CentOS, and I'm seeing an apparent deadlock which
is not resolving itself.
According to the postgres documentation, deadlocks should be detected and
resolved by killing one or more transactions involved.
On Tue, Nov 18, 2008 at 2:02 PM, Scara Maccai [EMAIL PROTECTED] wrote:
SELECT A FROM myTAB where A 1
only uses the index (if there's an index defined for A) in Oracle.
Well, not exactly. That's called a covered index because the query
could be satisfied directly from the index (the
On Tue, Nov 18, 2008 at 11:43 AM, Michael P. Soulier
[EMAIL PROTECTED] wrote:
Hello,
I'm working with Pg 7.4 on CentOS, and I'm seeing an apparent deadlock which
is not resolving itself.
According to the postgres documentation, deadlocks should be detected and
resolved by killing one or
Jonah H. Harris wrote on 18.11.2008 20:15:
On Tue, Nov 18, 2008 at 2:02 PM, Scara Maccai [EMAIL PROTECTED] wrote:
SELECT A FROM myTAB where A 1
only uses the index (if there's an index defined for A) in Oracle.
Well, not exactly. That's called a covered index because the query
could be
On Tue, Nov 18, 2008 at 12:33 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
If all the columns from the select list are available in the index, then
Oracle will always prefer the index scan over a table scan (at least I have
never seen something else). Even for a SELECT that returns all rows of
On Tue, Nov 18, 2008 at 2:33 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
If all the columns from the select list are available in the index, then
Oracle will always prefer the index scan over a table scan (at least I have
never seen something else). Even for a SELECT that returns all rows of
On Tue, Nov 18, 2008 at 1:03 PM, Jonah H. Harris [EMAIL PROTECTED] wrote:
On Tue, Nov 18, 2008 at 2:57 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Sounds like they're borrowing the code from innodb that does much the
same thing. In Innodb, if a field is indexed, it lives only as an
index, not
On Tue, Nov 18, 2008 at 2:57 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Sounds like they're borrowing the code from innodb that does much the
same thing. In Innodb, if a field is indexed, it lives only as an
index, not in the table and an index at the same time.
They aren't borrowing
On Tue, Nov 18, 2008 at 1:07 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Tue, Nov 18, 2008 at 1:03 PM, Jonah H. Harris [EMAIL PROTECTED] wrote:
On Tue, Nov 18, 2008 at 2:57 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Sounds like they're borrowing the code from innodb that does much the
same
On Tue, Nov 18, 2008 at 3:07 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
They aren't borrowing anything, Oracle has had this functionality
since at least Oracle 8i (1999).
Whoa, calm down Francis.
My name's not Francis :)
I'm not suggesting they stole it or something. Just that they're
On Tue, Nov 18, 2008 at 3:09 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Oh, and citation needed. I don't remember seeing anything about
oracle using indexes as sole storage units back in 8i
Your memory-foo is weak. See ORGANIZATION INDEX:
On Tue, 2008-11-18 at 15:28 -0500, Jonah H. Harris wrote:
On Tue, Nov 18, 2008 at 3:09 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Oh, and citation needed. I don't remember seeing anything about
oracle using indexes as sole storage units back in 8i
Your memory-foo is weak. See
On Tue, Nov 18, 2008 at 3:45 PM, Joshua D. Drake [EMAIL PROTECTED] wrote:
Off topic much?
Hey, all I did was make a joke; other people wanted to get all
*correct* about it :)
Anyway, as this has been discussed at least twenty times before, this
is a waste of a thread.
--
Jonah H. Harris,
Scott Marlowe wrote:
They aren't borrowing anything, Oracle has had this functionality
since at least Oracle 8i (1999).
Whoa, calm down Francis. I'm not suggesting they stole it or
something. Just that they're using the same basic concepts.
Oh, and citation needed. I don't
On Tue, Nov 18, 2008 at 11:09 AM, Pietro Tedesco
[EMAIL PROTECTED] wrote:
We have an instance of PostgreSQL on Windows 2003 with some application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a
Jonah H. Harris wrote on 18.11.2008 20:58:
On Tue, Nov 18, 2008 at 2:33 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
If all the columns from the select list are available in the index, then
Oracle will always prefer the index scan over a table scan (at least I have
never seen something else).
On Tue, Nov 18, 2008 at 3:54 PM, Thomas Kellerer [EMAIL PROTECTED] wrote:
Hmm. I was not talking about an index _fast full_ scan, I was talking about
index scans in general. Personally I have never seen Oracle using a table
scan (whatever kind) if all columns in the select are present in the
On 18/11/08 Scott Marlowe did say:
Just because you've got a blocking transaction doesn't mean it's a
deadlock. A deadlock means you have two transactions, each of which
is waiting for the other to continue before it can go on. If one
query is holding up another query, but not vice versa,
Hi,
I just released new RPM sets, which is based on Nov 18 2008 11:00 PM
EEST CVS snapshot.
These packages *do* require a dump/reload, even from previous 8.4
packages, because of a catversion update.
We have more than 400 testers using these sets.
As usual, please find detailed info from:
On 18/11/08 Michael P. Soulier did say:
I found this:
http://fishbowl.pastiche.org/2004/02/26/finding_open_locks_on_postgresql/
it revealed where the locks were consumed.
Does postgres implicitely lock tables? I noticed that I had an alter
table command but I didn't lock, and yet there
Michael P. Soulier [EMAIL PROTECTED] writes:
Does postgres implicitely lock tables? I noticed that I had an alter
table command but I didn't lock, and yet there was a lock being
requested on the table by that process...
Scott Marlowe wrote:
Serial is a pseudotype. It represents creating an int or bigint and
a sequence then assigning a default value for the column and setting
dependency in the db so the sequence will be dropped when the table
gets dropped. If you don't want to recreate the table, you can do
On Nov 18, 2008, at 10:37 AM, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, Nov 18, 2008 at 10:24 AM, Simon Connah
[EMAIL PROTECTED] wrote:
But whenever I try and update my column to this type it says that
it can not
find that data type. Am I doing something wrong?
Howard Cole wrote:
Unfortunately I am on a windows platform. Plus I am running windows
software raid so there is little tweaking allowed.
Don't write the possibility off too quickly. The driver may well accept
parameters for readahead settings etc, either through a custom
configuration applet
Hi,
I realise this may be a subjective topic ; however:
what does everyone think about grouping a set of functions together,
by related it maybe that they call on each other but more so live in
the same file on disk (before they get submitted) ... we are trying to
use the output of pg_dump for
On Tue, Nov 18, 2008 at 6:38 PM, Ravi Chemudugunta
[EMAIL PROTECTED] wrote:
Hi,
I realise this may be a subjective topic ; however:
what does everyone think about grouping a set of functions together,
by related it maybe that they call on each other but more so live in
the same file on disk
95 matches
Mail list logo