Hi
Iam getting the below error when iam running my program.
ERROR: cannot have more than 2^32-1 commands in a transaction
SQL state: 54000
If iam not wrong this error ocuurs when there are too many statements executing
in one single transaction.
But this error is occuring in a function that iam lea
Hi
I have written a program that imputes(or rather corrects data) with in
my database.
Iam using a temporary table where in i put data from other partitoined
table. I then query this table to get the desired data.But the thing
is this temporary table has to be craeted for every record that i need
t
performance?
Thanks
Samantha
On 4/8/08, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> samantha mahindrakar escribió:
>
> > So the program necessarily creates a temporary table evrytime it has
> > to correct a record. However this table is dropeed after each record
> >
to use a permanent table that is truncated
after one set of data is imputed.
I hope this makes sense.
Samantha
On Wed, Apr 9, 2008 at 6:44 AM, valgog <[EMAIL PROTECTED]> wrote:
> On Apr 7, 8:27 pm, [EMAIL PROTECTED] ("samantha mahindrakar")
> wrote:
>
>
> > Hi
wrote:
> On Apr 8, 2008, at 2:43 PM, Alvaro Herrera wrote:
>
> > samantha mahindrakar escribió:
> >
> > > Well instead of creating a temp table everytime i just created a
> > > permanant table and insert the data into it everytime and truncate it.
> > >
We store traffic data in the partitioned tables. But the problem is
that all this data is not correct. The data is corrupt, hence they
need to be corrected.
On Wed, Apr 9, 2008 at 10:31 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> On Apr 9, 2008, at 6:41 PM, samantha mahindrakar wro
Hi
Iam finding the following query is working a bit slow:
EXECUTE '(SELECT ARRAY(SELECT DISTINCT date_part(''day'', measurement_start)
FROM ' || gettablestring(dates)|| '
WHERE lane_id IN (' || lanesidarr || ')))'
INTO temparr;
This function is trying to find all the days in a prticular month
Hi
I have a select statement that runs on a partition having say couple
million rows.
The tabel has indexes on two colums. However the query uses the
non-indexed colums too in its where clause.
For example:
SELECT lane_id,measurement_start,
measurement_end,speed,volume,occupancy,quality,effective_d
quality,effective_date
FROM tss.lane_data_06_08
WHERE lane_id in(select lane_id from lane_info where inactive is null )
*AND measurement_start between '2008-06-30 05:00:00-04' AND '2008-06-30
23:00:00-04'*
GROUP BY
lane_id,measurement_start,measurement_end,speed,volume,occu
I am facing performance issues with running scheduled jobs. There are
multiple jobs running on the database ...not necessarily acting on the same
table. Either ways i checked if there was a locking issue, I did not find
any conflicting issues. The program is run over night ..when i check the
lo
Windows 2003 Server SP2
Intel Xeon 3.2 GHz
3.75 Gb RAM
System Drive 33.8 Gb
Data drive 956 Gb
PostgreSQL 8.2.6
PERC RAID 10 I believe SCSI disks
On 7/22/08, Craig Ringer <[EMAIL PROTECTED]> wrote:
>
> samantha mahindrakar wrote:
>
>> I am facing performance issues with r
11 matches
Mail list logo
