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
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 ve
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
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?
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
t
"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...
http://www.postgresql.org/docs/8.3/static/explicit-locking.html#LOCK
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 ther
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:
http
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,
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 th
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 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
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 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, Se
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 ORG
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:
http://download-west.oracle.com/docs/cd/A87860_01/
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
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
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 anyt
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
>> i
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
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
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
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 on
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
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.
http://www.postgresql.org/docs/current/static/explicit-lo
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
For the most part, that's all you needed
> 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 an
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
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 in
"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 rang
"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
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 is
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.
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 SELE
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
i
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 (pgsql-gener
Shane Ambler schreef:
ries van Twisk wrote:
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
Suppose I want to delete a record in tblnr1.
Does Postgres has some command/procedure/function to list tables
that have FK constraints on th
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 pgsql-gener
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');
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 "
>
> Ho
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
s
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
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 exam
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 (
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
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 ta
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 ('23/
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
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 so
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 or
ries van Twisk wrote:
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
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)
The
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 citat
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 thi
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
kern.ipc.sh
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: 68719
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 expla
"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 a
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 on
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
"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 relat
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, but
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.s
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() {
java.io.BufferedRead
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 TABL
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
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
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 »pld
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"
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 P
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
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 tblnr2(n
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
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
> m
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 oth
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.
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 integer)
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
kern.ipc.s
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
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 pro
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:
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
>
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 Com
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
sep
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
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 multip
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 beh
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
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 thers
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 thers
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
buildin
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 yo
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
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
95 matches
Mail list logo
