Hopefully I'm understanding your question correctly. If so, maybe
this will do what you are wanting.
First, a couple of questions. Do you have this data in a table
already, and are looking to extract information based on the dates?
Or, are you basically wanting something like a for loop so
Hi guys,
I've scoured the date/time functions in the docs as well as
google-grouped as many different combinations as I could think of to
figure this out without asking, but I'm having no luck.
I'd like to make a query that would return a list of every trunc'd
TIMESTAMPs between two dates. For e
Tom Lane wrote:
TRUNCATE and CLUSTER both rebuild indexes, so they'd also trigger the
leak.
Sorry to bug you again, but I have two quick followup questions: (1) is
the leak you discovered fixed on the 8.0 branch? and (2) would closing
the database connection once per day be a reasonable way t
Hello,
I have a pretty big database with about 200 000 rows.
This is the main table. Also some other tables with FKs to this main
table.
I have to calculate some numbers for each entry at a certain amount of
time and update the DB.
I've noticed the update TAKES a very long time.
For example i h
On Mon, Jun 27, 2005 at 01:05:42PM -0700, Dann Corbit wrote:
>
> > -Original Message-
> > From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> > Sent: Monday, June 27, 2005 12:58 PM
> > To: Dann Corbit
> > Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] Populating hu
On Mon, Jun 27, 2005 at 17:09:37 -0400,
Vivek Khera <[EMAIL PROTECTED]> wrote:
>
> On Jun 27, 2005, at 4:36 PM, John Browne wrote:
>
> >I'm interested in doing a project for calculating distances similar to
> >this. Anyone have suggestions on how/where this type of data can be
> >obtained? Is
Hello.
I created a Windows XP schedule for backup, following your instruction. Now
I have a .bat file with this script:
cd D:\Program Files\PostgreSQL\8.0\bin
pg_dumpall >D:\MYDATABASE_DUMPALL -U postgres
pg_dumpall >D:\MYDATABASE_SHEMA -U postgres -s
pg_dumpall >D:\MYDATABASE_GLOBALS -U postgr
I knew I would forget to include some obvious info. I'm running PG
8.0.x on WinXP and have vacuum full analyzed.
-Original Message-
From: Relyea, Mike
Sent: Monday, June 27, 2005 5:10 PM
To: 'pgsql-general@postgresql.org'
Subject: Indexes not used - what am I missing?
Given my query:
=
Given my query:
SELECT "PrintSamples"."MachineID" , "PrintSamples"."PrintCopyID" ,
"tblColors"."Color" , "tblBlockAC"."AreaCoverage" ,
"tblFriendlyParameterNames"."FriendlyParameterName" AS "Measurement" ,
"ParameterValues"."ParameterValue" AS "V
On Jun 27, 2005, at 4:36 PM, John Browne wrote:
I'm interested in doing a project for calculating distances similar to
this. Anyone have suggestions on how/where this type of data can be
obtained? Is it freely available anywhere?
Google is your friend. There are places that sell very well
I'm interested in doing a project for calculating distances similar to
this. Anyone have suggestions on how/where this type of data can be
obtained? Is it freely available anywhere?
On 6/27/05, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote:
>
> Actually it does.
> I'm using a bounding box too. I
> -Original Message-
> From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 27, 2005 12:58 PM
> To: Dann Corbit
> Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Populating huge tables each day
>
> On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corb
On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corbit wrote:
> I see a lot of problems with this idea.
>
> You mention that the database is supposed to be available 24x7.
> While you are loading, the database table receiving data will not be
> available. Therefore, you will have to have one serve
Actually it does.
I'm using a bounding box too. I have a stored procedure to get me what I need -
here's the relevant part of it.
Explanation: zc is the record holding the point of origin. I just added the
maxdistance definition for this, because in my function its a parameter.
SELEC
I see a lot of problems with this idea.
You mention that the database is supposed to be available 24x7.
While you are loading, the database table receiving data will not be
available. Therefore, you will have to have one server online (with
only the old data), while the other one is loading. Onc
In the following output the vacuum knows there are 99,612
pages and 1,303,891 rows. However the last line of output during the analyze
only thinks there are 213,627 rows. Is this so far off because the table is
bloated? Version of PostgreSQL is “PostgreSQL 7.4.3 on
i686-pc-linux-gnu, com
Hi All,
First I apologize for the length of this email im just afraid that my
problem is quite complicated for explination & also about my english
which is not my native language sorry :)
I'm currently building a site for a client which will need to update his
database on a daily routine
Magnus Hagander schrieb:
Did you check the eventlog? It's supposed to write it there..
Well, you are right. =8-}
There is "FATAL: Syntaxfehler in Datei
»[...]/PostgreSQL-8.0.3/postgresql.conf«, Zeile 322, bei »#«"
That's the error message I got on the console.
I'm by far no Windows guru
Hi,
We are having strange problem on production system with very slow
insert/delete commands and huge cpu and disk write activity spikes in
postgresql 7.2.4. This behavior is very reproducible and happens in
following sequence :
1. full db vacuum
2. several hundred of insert/delete commands are pe
> I want to warn you all that you might hurt yourself by
> banging your head against the wall or damage your karma by
> using foul language if you find your postmaster rejecting to
> work after a minor change in the postgresql.conf. (I changed
> the listenig address to an IP instead of *.) Wind
I want to warn you all that you might hurt yourself by banging your head
against the wall or damage your karma by using foul language if you find
your postmaster rejecting to work after a minor change in the
postgresql.conf. (I changed the listenig address to an IP instead of *.)
Windows can't s
On Mon, 2005-06-27 at 10:50, Alvaro Herrera wrote:
>
> Regarding replication, the Slony-I guys state that their project is not
> yet ported to Windows, but giving that there is a pthread library for
> Windows (which is about the only thing it lacks, apparently) then it
> should be possible to por
On Jun 27, 2005, at 8:29 AM, K.Deepa wrote:
Dear All,
Is there any way to check the santity of the backup taken using
pg_dump?
Send it to a psychotherapist?
The only way to verify a backup is to restore from it and check it
however you can (compare with original if it is unaltered, or
> > > I currently maintain a website which is deployed on LAMP,
> but it is
> > > developed on Windows (WAMP?). I'm considering moving both to use
> > > PostgreSQL. I'm curious as to whether others are following a
> > > similar development/deployment model and if so, what
> > > pitfalls/gotc
On Mon, Jun 27, 2005 at 01:59:42PM +0200, Magnus Hagander wrote:
> > I currently maintain a website which is deployed on LAMP, but
> > it is developed on Windows (WAMP?). I'm considering moving
> > both to use PostgreSQL. I'm curious as to whether others are
> > following a similar development
On Sun, Jun 26, 2005 at 16:40:03 -0700,
CSN <[EMAIL PROTECTED]> wrote:
> If I have a table of items with latitude and longitude
> coordinates, is it possible to find all other items
> that are within, say, 50 miles of an item, using the
> geometric functions
> (http://www.postgresql.org/docs/8.0/
On Sun, Jun 26, 2005 at 15:42:25 -0500,
Peter Fein <[EMAIL PROTECTED]> wrote:
>
> Is there anyway to create an infix version of this? I'd really like be
> able to write (where a..d are some boolean conditions):
Use <>:
area=> select true <> false <> true;
?column?
--
f
(1 row)
area=
Dear All,
Is there any way to check the santity of the backup taken using pg_dump?
--
regards,
Deepa K
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Jun 26, 2005, at 7:40 PM, CSN wrote:
If I have a table of items with latitude and longitude
coordinates, is it possible to find all other items
that are within, say, 50 miles of an item, using the
geometric functions
(http://www.postgresql.org/docs/8.0/interactive/functions-
geometry.html)?
On Jun 27, 2005, at 3:47 AM, Janning Vygen wrote:
I had some problems with the calculation inside acos() sometimes
being greater
than 1, which should not occur. Please use a
CASE WHEN sin(...) > 1 THEN 1 ELSE sin(...) END
if you have the same problem.
We've seen this as well with the di
Zac <[EMAIL PROTECTED]> writes:
> does anyone know if there is a way (in plpgsql) to obtain the number of
> records returned by a cursor without fetching them all?
No. The system itself does not know that until you've fully executed
the query ...
regards, tom lane
-
Himanshu Baweja <[EMAIL PROTECTED]> writes:
> i just have one raid controller with 6 disks
> attached... i see all of it as single drive with three
> partitions create by me...
>
> will creating tablespaces help me also is there a
> way i can say this table to this disk???
In a RAID, all data
# [EMAIL PROTECTED] / 2005-06-23 17:25:03 -0400:
> On Thu, 2005-06-23 at 03:39 +, Karl O. Pinc wrote:
> > On 06/22/2005 08:23:43 AM, Sven Willenberger wrote:
> > > On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote:
> > > > # [EMAIL PROTECTED] / 2005-06-21 15:00:12 -0400:
> > > > > We hav
thank you Andreas!
- Original Message -
From: "Andreas" <[EMAIL PROTECTED]>
To:
Cc: "Zlatko Matic" <[EMAIL PROTECTED]>
Sent: Monday, June 27, 2005 12:43 PM
Subject: Re: [GENERAL] automating backup ?
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP
Teunis Peters wrote:
This has to do with building postgresql-8.0.3
I'm installing on a MacOSX system (10.3) and configure's failing to
find the readline installation.
Installing the vanilla readline library from source now works great on 10.3.
If you first install this using the standard .
> Hello!
> I'm trying to install postgresql on WindowsXP box using
> postgresql-8.0.msi.
> The installation goes fine until running the service. I get a
> message saying that postgre-8.0 failed to run as a service. I
> checked system log and came across an error saying
> that: PostgreSQL Databas
> I currently maintain a website which is deployed on LAMP, but
> it is developed on Windows (WAMP?). I'm considering moving
> both to use PostgreSQL. I'm curious as to whether others are
> following a similar development/deployment model and if so,
> what pitfalls/gotchas they have found. F
Hello!
I'm trying to install postgresql on WindowsXP box using postgresql-8.0.msi.
The installation goes fine until running the service. I get a message
saying that postgre-8.0
failed to run as a service. I checked system log and came across an
error saying
that: PostgreSQL Database Server 8.0
On Sun, 2005-06-26 at 10:59 -0700, Bob Pawley wrote:
> I'll date myself so you all may know from where I am coming. My first lesson
> in binary math took place in a classroom in 1958. Since then I have
> witnessed a lot that has since swept under the bridge.
>
>
>
> This thread reminds me of t
I currently maintain a website which is deployed on LAMP, but it is developed on
Windows (WAMP?). I'm considering moving both to use PostgreSQL. I'm curious as
to whether others are following a similar development/deployment model and if
so, what pitfalls/gotchas they have found. For example,
Tom Lane wrote:
Found it --- the actual leak is in index_create, not in TRUNCATE or
CLUSTER at all; and it's been there a really long time.
Patch for 7.4 branch attached.
Excellent! Does index_create refer to something that is invoked as a
consequence of CREATE INDEX? I'm looking through the
Zlatko Matic schrieb:
Thanks Fuhr.
Anybody can tell me how to do it on Windows XP ?
Thanks.
That's again a pure Windows issue, but not commonly needed.
I guess, it should be in the Windows PG-FAQ, too.
I'll describe the way you go with Windows 2000.
If you are lucky WinXP Pro does it the sam
Hi,
does anyone know if there is a way (in plpgsql) to obtain the number of
records returned by a cursor without fetching them all?
Using "FOUND" and "GET DIAGNOSTICS row_count" variables doesn't help me:
the only way seems to be fetching all the records.
I try to explain it better:
CREATE
DB Comparer tool seems very useful.
Thank you for your suggestions and links.
Milorad Poluga
HK CORES Beograd, Makenzijeva 31
[EMAIL PROTECTED]
+381-11-30-80-461
---(end of broadcast)---
TI
On Sun, 2005-06-26 at 11:18 +0200, Zlatko Matic wrote:
> How to automate backup, so that Postgres automatically backups, for example,
> once in a week ?
> The same question about vacuum ?
>
> Concerning backup, how to prevent that someone makes a copy (for example
> pg_dumpall) of a database,
Uwe C. Schroeder wrote:
in the where clause use something like (requires the earthdistance contrib to
be installed):
geo_distance(point([origin longitude],[origin latitude]),point([target
longitude column],[target latitude column])))::int <= 50
I don't suppose geo_distance really returns
How big is your data ? There are rather sophisticated and
very effective methods in astronomy. For example,
http://www.sai.msu.su/~megera/oddmuse/index.cgi/SkyPixelization,
http://www.sai.msu.su/~megera/oddmuse/index.cgi/pg_sphere
Oleg
On Mon, 27 Jun 2005, Janning Vygen wrote:
Am Monta
Hi,
after months of flawless operation I get the following error when
running VACUUM ANALYZE
vacuumdb: vacuuming database "CLIX2"
vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link
changed unexpectedly
System: Fedora Core 2, 2.6.10-1.771_FC2
Postgres 7.4.2
What does
in the where clause use something like (requires the earthdistance contrib to
be installed):
geo_distance(point([origin longitude],[origin latitude]),point([target
longitude column],[target latitude column])))::int <= 50
On Sunday 26 June 2005 04:40 pm, CSN wrote:
> If I have a table of items
Am Montag, 27. Juni 2005 01:40 schrieb CSN:
> If I have a table of items with latitude and longitude
> coordinates, is it possible to find all other items
> that are within, say, 50 miles of an item, using the
> geometric functions
> (http://www.postgresql.org/docs/8.0/interactive/functions-geometr
50 matches
Mail list logo
