.
Regards
Michal Szymanski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In our DB we create partition table for each month (our naming
convetion is follow , and I would like to create trigger that insert
data to appropriate partition table accounting.cdr_y2009m05,
accounting.cdr_y2009m06 etc..).
What is the best solution to create such trigger? I can create trigger
fu
On 10 Paź, 04:38, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Alvaro Herrera writes:
> > Michal Szymanski wrote:
> >> In old version of Postgres we have to execute 'VACUUM FULL' to solve
> >> problem of transaction ID wraparound, do we need to execute 'V
Hi,
In old version of Postgres we have to execute 'VACUUM FULL' to solve
problem of transaction ID wraparound, do we need to execute 'VACUUM
FULL' in Postgres 8.3 or 8.4 to avoid this problem?
How to check using SQL if transaction ID is close to wraparound?
M
> Michal Szymanski writes:
> > CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
> > test VARCHAR)
> > AS $$
> > BEGIN
> > -- @todo hide password
> > RETURN QUERY
> > SELECT id ,test
> > FROM b
-
it returns 1 but empty row. What is wrong with this?
Regards
Michal Szymanski
http://blog.szymanskich.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> I've used Pentaho with pgsql and it worked pretty well. I'm pretty
> sure jasper as well can work with pgsql.
Where can I find information how to install Pentaho on Postgres? Do
you use free edition?
Regards
Michal Szymanski
--
Sent via pgsql-general mailing lis
Hi,
I'm looking for free software that provide OLAP functionality (or more
general BI) for data that are stored in Postgres database. I've found
Pentaho and Jasper but both sollution are configured for MySQL. Can
you recomend something that works with postgres?
Regards
--
Sent via pgsql-general
?
Does it work when you call it from PGAdmin?
select * from cerber.cerber_account_select (1);
Michal Szymanski wrote:
Hi,
We call DB procedure that select rows with given ID it works as simple
SELECT but for future changes we implement as DB procedure (look below
for DB listing). Recently we
We use Postgres 8.3.7 on Linux
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
We call DB procedure that select rows with given ID it works as simple
SELECT but for future changes we implement as DB procedure (look below
for DB listing). Recently we modified columns in table
cerber.cerber_accoun and after this modification procedure does not
work anymore and it returns
42
* with only the index (or only the primary key) the insert rate is
> good at start (for the first 2 million readings), but then drops to
> about 200 inserts / s;
Try periodicaly execute REINDEX your index, and execute ANALYZE for
your table . To be honest should not influance on inserts bu
8.3. It is small thing but sometimes is hard to debug our
procedures.
Michal Szymanski
http://blog.szymanskich.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g i_cdr_id is locked and
second transaction wait even with select.
Now problem is solved , at least I've not recorded situation when
account is charged twice.
Thank you for your help.
Michal Szymanski
http://blog.szymanskich.net
--
Sent via pgsql-general mailing list (pgsql-ge
Hi,
I develop telecommunication software and I have encountered problem
with isolation level in Postgres.
Our database receive special packets that informs about end of call,
and from time to time (it happens when such packets arrive almost in
the same time e.g 8ms difference) one call charge user
15 matches
Mail list logo
