wondering where to query for the physical size of a column (returned in bytes) in a row? i looked into the information_schema but i think that's more for getting triggers, views, etc.
New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.
I will first check the logfiles then the stale pid file.
On 4/12/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
>
> if postmaster is running and i do,
>
> kill -9 -1
> i.e. i did abrupt shut down
>
> now when i brought back the system
>
> i am not able to start postmaster
>
> actually i want to simu
if postmaster is running
and i do,
kill -9 -1
i.e. i did abrupt shut downnow when
i brought back the system
i am not able to start postmaster
actually i want to simulate, the scenario is
which the user will do
'hard shut down / Power off'while system is in working
state..
and i want to ens
> For generation in Excel, you can just use File->Save, and select CSV as
> the format. You can use either CSV or tab delimited, really.
I am not sure if it matters with postgresql, but other programs require
(MS-DOS) CSV format rather
than the initial CSV choice.
Regards,
Richard
On Tue, 2006-04-11 at 23:13 +0200, Magnus Hagander wrote:
> > Hello,
> >
> > I am trying to import an Excel file in my database (8.0.7). I
> > think I am supposed to create an CSV file out of my Excel
> > file and somehow, feed the database with it. My pronblem is
> > that I don't really know h
On Mon, Apr 10, 2006 at 10:43:16PM -0700, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solv
> Hello,
>
> I am trying to import an Excel file in my database (8.0.7). I
> think I am supposed to create an CSV file out of my Excel
> file and somehow, feed the database with it. My pronblem is
> that I don't really know how to do it... :( Can anyone give
> me a hint about how to do that?
>
On mán, 2006-04-10 at 22:43 -0700, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the p
On Tue, 2006-01-24 at 11:33 +0100, FERREIRA, William (VALTECH) wrote:
> the times are always the same, except with the centrino for which it takes 1
> min.
Oracle or PostgreSQL? i.e. is the Centrino faster or slower?
> -Postgresql plan :
Please post the EXPLAIN ANALYZE.
Thanks,
--
Simon Ri
On Tue, 2006-04-11 at 00:43, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the problem
On Tue, 2006-04-11 at 00:43, [EMAIL PROTECTED] wrote:
> Hi
>Now we cannot change the field type. Because already our application
> is running and thousands of records are already entered. we are getting
> same no for clipid when 2 users are entering data at a time. so how to
> solve the problem
On Wed, Apr 05, 2006 at 10:15:18PM +0200, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> Martijn van Oosterhout writes:
>
> > As a british user, latin9 will cover most of your needs, unless
> > ofcourse someone wants to enter their name in chinese :)
>
> Since british users don't use Fr
Hi,
I think you question if for NOVICE group.
However,
1. Unzip:
gunzip postgresql_autodoc-1.25.tar.gz
2. Extract from tar
tar -xvf postgresql_autodoc-1.25.tar.gz
3. Enter the directory
cd postgresql_autodoc
3.1. !READ README file or READ INSTALL file
I presume then you should :
4. Run Con
Hello,
I am trying to import an Excel file in my database (8.0.7). I think I am
supposed to create an CSV file out of my Excel file and somehow, feed the
database with it. My pronblem is that I don't really know how to do it... :(
Can anyone give me a hint about how to do that?
One last "detail"
Hi
Now we cannot change the field type. Because already our application
is running and thousands of records are already entered. we are getting
same no for clipid when 2 users are entering data at a time. so how to
solve the problem
---(end of broadcast)
> This is because many applications are
> written for in-house consumption, simple web sites, etc. and those
> applications are not GPL.
In-house use cannot violate the GPL. The GPL requires that source be made
available without further restrictions, but only to those to whom the app is
distribute
>> also, i'd be happy to listen opinions from people who have experience
> of usage
>> of such things like soundex.
>
>
> Soundex is grossly outdated. It was designed for manual use by 19th century
> census takers, and I'm always surprised to see it still used. Metaphone
> (google search gets goo
Michael Fuhr wrote:
On Thu, Apr 06, 2006 at 03:36:33PM -0400, Emi Lu wrote:
How to check whether a table is locked?
You can monitor locks by querying the pg_locks view.
http://www.postgresql.org/docs/8.0/interactive/monitoring-locks.html
http://www.postgresql.org/docs/8.0/interactive/view-pg-
> also, i'd be happy to listen opinions from people who have experience
of usage
> of such things like soundex.
Soundex is grossly outdated. It was designed for manual use by 19th century
census takers, and I'm always surprised to see it still used. Metaphone
(google search gets good results) doe
Milen Kulev wrote:
Hi Listers,
I have the following problem (OS= RHELU2 , PG version= 8.1.3) when I try to
Create a database :
postgres=# CREATE DATABASE world3 TEMPLATE=template1 ENCODING='UTF8'
TABLESPACE=tbs1 ;
CREATE DATABASE
Then I am backup-ing the database (a small toy DB) with pg_
"Just Someone" <[EMAIL PROTECTED]> writes:
> The documentation say that a recovery.conf file is needed for the
> restore. My tests indicate that I can just restore the backup, copy
> over the latest WAL files and launch postgres. Is that ok? Can I just
> use this way?
If by "latest" you mean "all
I have a process for PITR backups running nicely. I'm pretty amazed by
the smoothness of it all!
Now I'm looking at the retrieval part, and I have something I'm
looking for clarification on.
The documentation say that a recovery.conf file is needed for the
restore. My tests indicate that I can ju
[EMAIL PROTECTED] wrote:
On Tue, Apr 11, 2006 at 09:52:40AM +0200, hubert depesz lubaczewski wrote:
On 4/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
What I was hoping for was some general insight from the EXPLAIN
ANALYZE, that maybe extra or different indices would help, or if there
On Tue, Apr 11, 2006 at 09:52:40AM +0200, hubert depesz lubaczewski wrote:
> On 4/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > What I was hoping for was some general insight from the EXPLAIN
> > ANALYZE, that maybe extra or different indices would help, or if there
> > is some better me
Oscar Picasso wrote:
I guess I also need a database of the cities coordinates. Where could
I find one?
You can download US data here:
http://geonames.usgs.gov/domestic/download_data.htm
These are tables of geo entities with a number of columns, including
lat/long. NGA (formerly NIMA) has
On 4/11/06, MG <[EMAIL PROTECTED]> wrote:
> In on extreme case the application makes 100 000 INSERTs, in the other
> extreme case 100 000 UPDATES. Normally the UPDATES are more that INSERTs.
> Here I notice that the first case (100 000 INSERTs) takes about 30 minues,
> but the 100 000 UPDATES a
> -Original Message-
> From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
> Sent: 11 April 2006 14:02
> To: Dave Page
> Cc: Alban Hertroys; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED]; p
Michael Fuhr wrote:
On Tue, Apr 11, 2006 at 12:54:12PM +0100, Ricardo Manuel Pereira Vilaça wrote:
How I can determine information about the last committed transaction in
postgresql?
What information are you looking for? What are you trying to do?
When a server restarts, and pos
On Tue, Apr 11, 2006 at 05:28:12AM -0700, Nikolay Samokhvalov wrote:
> hello.
>
> does anybody know any solutions to the problem of searching
> words/phrases, which are close to each other by sounding? e.g. soundex
> index or smth.
Check out contrib/fuzzystrmatch. It has a number of such algorith
On Tue, Apr 11, 2006 at 12:02:33PM +0100, Dave Page wrote:
> > The only proper fix for this licensing issue IMHO is to fix
> > GPL, not to kludge in some GPL compliant library. The issue
> > at hand obviously is licensing related, the software is not
> > the problem. And the cause of the licensi
hello.
does anybody know any solutions to the problem of searching
words/phrases, which are close to each other by sounding? e.g. soundex
index or smth.
problem I have: tag suggestion mechanism, similar to google suggest,
which is intended to suggest names of people (search field "person's
name"
On Tue, Apr 11, 2006 at 12:54:12PM +0100, Ricardo Manuel Pereira Vilaça wrote:
> How I can determine information about the last committed transaction in
> postgresql?
What information are you looking for? What are you trying to do?
--
Michael Fuhr
---(end of broadcast)
The possible solution would be, that you first insert the file into a temporary table via COPY.
have a full outer join on you current table with the temporary one on the basis of the primary column(s) assuming id.
only update the column where the outer table join is not null and insert all the rows
Hi,
How I can determine information about the last committed transaction in
postgresql?
Thanks,
Ricardo Vilaça
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
I have the following scenario:
The application read one record from a file, which contains 100 000 records.
The application checks on different conditions if this record is allready
save in the table 'test'.
If this record exists then the application manipulates record and updates
the recor
> -Original Message-
> From: Alban Hertroys [mailto:[EMAIL PROTECTED]
> Sent: 11 April 2006 10:45
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; pgsql-general@postgresql.
am 11.04.2006, um 12:15:41 +0200 mailte Alban Hertroys folgendes:
> MG wrote:
> >I have to improve the performance of the UPDATES and I was wondering why
> >the UPDATEs need twice as long as the INSERTs.
>
> IIRC, an UPDATE is a DELETE/INSERT combo. That's because the original
> record still ne
Hugo wrote:
Hi, how can I tell in which order are triggered different triggers on the
same table, let me explain ,
I have three triggers for table A, all of then are intended for "before
insert" on the table, in ASA I can tell the Db in which order I want the
triggers to fire, is there an equival
MG wrote:
I have to improve the performance of the UPDATES and I was wondering why
the UPDATEs need twice as long as the INSERTs.
IIRC, an UPDATE is a DELETE/INSERT combo. That's because the original
record still needs to be visible to other existing transactions (because
of MVCC). You can't
Andrew - Supernews wrote:
On 2006-04-10, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Notice the "INSERT" there. For a restore, you'd expect it to be "COPY",
_unless_ you used the -d option to pg_dump (this is a common mistake to
make, given that all the other utilities use -d to specify the databas
Hi,
On Tuesday 11 April 2006 11:40, MG wrote:
| I can`t use COPY or put it in a transaction, because the application which
| writes in PostgreSQL decides if it`s an INSERT or a UPDATE which depends on
| different conditions and also manipulate the records.
I don't see a reason that stops you fro
am 11.04.2006, um 11:32:55 +0200 mailte MG folgendes:
> I can`t use COPY for INSERTs, because I have to manipulate each record
> indiviuell.
>
> But the problem is the UPDATEs
test=# \timing
Timing is on.
test=# update mira set y = 123;
UPDATE 15
Time: 1874.894 ms
150 000 Records, a simpl
Dave Page wrote:
The note on the fsf directory (http://directory.fsf.org/gnutls.html) is a
little off-putting:
"The program is currently in development and at an alpha stage."
Not to mention that from what I can see in a brief Google the Windows support
is somewhat rudimentary.
Regards, Dave
a single complex insert/update sql would be always faster compared to having a cursor and manipulating the data.
Again, it depends on what is the logic, and where actually you have the data.
cool.
L.
On 4/11/06, MG <[EMAIL PROTECTED]> wrote:
I can`t use COPY for INSERTs, because I have to manip
I can`t use COPY or put it in a transaction, because the application which
writes in PostgreSQL decides if it`s an INSERT or a UPDATE which depends on
different conditions and also manipulate the records.
In on extreme case it can be only INSERTs, in the other extreme case all can
be UPDATES. N
I can`t use COPY for INSERTs, because I have to manipulate each record
indiviuell.
But the problem is the UPDATEs
Greetings
Michaela
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 11, 2006 11:20 AM
Subject: Re: [GENERAL] Performance UPDATE/I
Hi,
On Tuesday 11 April 2006 11:08, MG wrote:
| I have about 100 000 records, which need about 30 minutes to write them
| with single INSERTs into PostgreSQL. If I go through these 100 000 records
| and make an UPDATE on each record, it takes 1 hour.
|
| Can anyone tell me, about his experience of
On Mon, Apr 10, 2006 at 02:58:50PM -0700, Tyler MacDonald wrote:
> Dave Page wrote:
> > > GnuTLS is LGPL, which isn't quite as liberal as postgresql's
> > > license, but should still be ubiqutous enough to be worthwhile.
> >
> > The note on the fsf directory (http://directory.fsf.org/gnutls.htm
am 11.04.2006, um 11:08:57 +0200 mailte MG folgendes:
> Hello,
>
> I have about 100 000 records, which need about 30 minutes to write them with
> single INSERTs into PostgreSQL.
You should better use the COPY - command for bulk inserts. This is
faster.
HTH, Andreas
--
Andreas Kretschmer(
Hello,
I have about 100 000 records, which need about 30 minutes to write them
with single INSERTs into PostgreSQL.
If I go through these 100 000 records and make an UPDATE on each record, it
takes 1 hour.
Can anyone tell me, about his experience of the performance of INSERT and
UPDATE.
[EMAIL PROTECTED] wrote:
Hi,
I'm interested in using postgresql_autodoc to document my postgres databases
on Linux, but I'm unable to find any information on how to install the
program or use it. Can someone point me in the right direction?
I've downloaded postgresql_autodoc-1.25.tar.gz from
h
On 4/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
It is, but it is only 32 msec because the query has already run andcached the useful bits. And since I have random values, as soon as Ilook up some new values, they are cached and no longer new.
according to my experiene i would vote for to
> -Original Message-
> From: Tyler MacDonald [mailto:[EMAIL PROTECTED]
> Sent: 10 April 2006 22:59
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-general@postgresql.org
> Subject: Re: [G
53 matches
Mail list logo
