n
MASTER_PID=`head -n 1 ${PIDFILE}`
echo $MASTER_PID
else
echo ""
fi
}
--
Mit freundlichen Gruessen / With best regards
Reiner Dassing
---(end of broadcast)---
TIP 8: explain analyze is your friend
#x27;data' and 'Data' is something
different.
--
--
Mit freundlichen Gruessen / With best regards
Reiner Dassing
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hello Tom!
Tom Lane wrote:
>
> Reiner Dassing <[EMAIL PROTECTED]> writes:
> > explain select * from wetter order by epoche desc;
> > NOTICE: QUERY PLAN:
>
> > Index Scan Backward using wetter_epoche_idx on wetter
> > (cost=0.00..3216018.59 rows=2034
tter where epoche between '1970-01-01' and '1980-01-01'
order by epoche asc;
?
Any ideas?
--
Mit freundlichen Gruessen / With best regards
Reiner Dassing
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
width=16)
EXPLAIN
Select where the index is NOT used:
===
explain select * from wetter where epoche between '1970-01-01' and
'1980-01-01' order by epoche asc;
NOTICE: QUERY PLAN:
Sort (cost=480705.74..480705.74 rows=203400 width=16)
-> S
Another possible approach would be to make selects which give back
results to be
used as table names.
I.e., it would be necessary to have something like
create table f(NEW.val) as select
where f(...) gives back a name of a table.
Tom Lane wrote:
>
> Reiner Dassing <[EMAIL
; AND
sensor_id = 1;
UPDATE 0
The insert notice can be shown!
The update notice is not there!
Why?
--
Mit freundlichen Gruessen / With best regards
Reiner Dassing
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
imit 1;
NOTICE: QUERY PLAN:
Sort (cost=12692.74 rows=202175 width=16)
-> Index Scan using wetter_pkey on table (cost=12692.74 rows=202175
width=16)
EXPLAIN
--
Reiner Dassing
Bruce Momjian wrote:
>
> > Reiner Dassing <[EMAIL PROTECTED]> writes:
> > > The primary index must be the epoch.
> > > As there will be no deletion from this data I fear - due to the
> > > internal representation of B-trees - the performance will degrade
Hi!
I am thinking about the best structure of a database to describe timely ordered
values.
The timely ordered values are the results of different sensors measuring
environmental
parameters like temperatur, pressure, humidity.
The database has to define the kind of measurements, kind of sensors,
10 matches
Mail list logo
