Jim Nasby wrote:
On 12/9/15 7:59 PM, Berend Tober wrote:
This project is a game, btw, described at
You might be interested in https://schemaverse.com/
Schemaverse looks somewhat interesting. Seems like it and Fairwinds
share in common Postgresql as a foundation, but they are very different
> test=> delete from cash_journal where ARRAY[click, cash_journal_id] NOT in
> (select max(ARRAY[click,cash_journal_id]) from cash_journal group by
> fairian_id); DELETE 7
For what it's worth, we've run into *severe* performance issues using in() if
there are a large number of values in conjunct
On Saturday, December 05, 2015 11:08:05 AM Berend Tober wrote:
> WITH max_click AS (
>SELECT
> cash_journal.fairian_id,
> max(cash_journal.click) AS click
> FROM cash_journal
> GROUP BY cash_journal.fairian_id
> )
>delete from cash_journal j
> using max_click b
On 12/9/15 7:59 PM, Berend Tober wrote:
The issue is that I'd like the application (that is, the data base and
its stored procedures) to be robust enough to be a "long-running"
application, i.e. one that doesn't suffer gradual performance
degradation as time and the accumulated data increase.
I
Steve Crawford wrote:
The two general solutions are the "keep the last one" proposed by Adrian
"keep the last N" that I sent.
But it might be worth stepping back a bit. You said you are having
performance problems that you feel would be improved by removing only a
million rows which doesn't soun
The two general solutions are the "keep the last one" proposed by Adrian
"keep the last N" that I sent.
But it might be worth stepping back a bit. You said you are having
performance problems that you feel would be improved by removing only a
million rows which doesn't sound like that much to me.
On Wed, Dec 9, 2015 at 1:31 PM, Adrian Klaver
wrote:
> On 12/09/2015 12:24 AM, Berend Tober wrote:
>
>> Adrian Klaver wrote:
>>
>>> On 12/05/2015 08:08 AM, Berend Tober wrote:
>>>
/*
Deletion Challenge
I want to delete all but the most recent transaction, per person, from
On 12/09/2015 12:24 AM, Berend Tober wrote:
Adrian Klaver wrote:
On 12/05/2015 08:08 AM, Berend Tober wrote:
/*
Deletion Challenge
I want to delete all but the most recent transaction, per person, from a
table that records a transaction history because at some point the
transaction history gr
Adrian Klaver wrote:
On 12/05/2015 08:08 AM, Berend Tober wrote:
/*
Deletion Challenge
I want to delete all but the most recent transaction, per person, from a
table that records a transaction history because at some point the
transaction history grows large enough to adversely effect performa
Steve Crawford wrote:
If I understand correctly the value of "click" always advances and within a
"click" the
"cash_journal_id" always advances - not necessarily by single steps so within a
fairian_id, ordering
by "click" plus "cash_journal_id" would return the records in order from which
you
On 12/05/2015 08:08 AM, Berend Tober wrote:
> /*
>
> Deletion Challenge
>
> I want to delete all but the most recent transaction, per person, from a
> table that records a transaction history because at some point the
> transaction history grows large enough to adversely effect performance,
> and
If I understand correctly the value of "click" always advances and within a
"click" the "cash_journal_id" always advances - not necessarily by single
steps so within a fairian_id, ordering by "click" plus "cash_journal_id"
would return the records in order from which you want the most recent 5 for
2015-08-18 7:08 GMT-03:00 Mitu Verma :
> Hi,
>
> I need to delete following threads posted by me on postgreSQL forum,
>
> Kindly suggest me a way forward as it is urgent.
FYI, see note 1 [1] in the subscribe page [2].
[1] https://wiki.postgresql.org/wiki/Archives_Policy
[2] http://www.postgresql
On 8/18/2015 3:08 AM, Mitu Verma wrote:
I need to delete following threads posted by me on postgreSQL forum,
Kindly suggest me a way forward as it is urgent.
good luck with that.email is write-only
the postgres mailing lists are archived on dozens and dozens of
different systems
--
On 08/28/2014 04:22 AM, Ramesh T wrote:
OK.. i created a function for delete customer from different tables in
single database.
i want rollback..
my question:
where i need to place rollback ,with in a
function along with deletion statements..? or after run the function .
On 08/28/2014 04:22 AM, Ramesh T wrote:
OK.. i created a function for delete customer from different tables in
single database.
i want rollback..
my question:
where i need to place rollback ,with in a
function along with deletion statements..? or after run the function .
On Thu, Aug 28, 2014 at 9:59 AM, Ramesh T [via PostgreSQL] <
ml-node+s1045698n5816744...@n5.nabble.com> wrote:
> OK.. i created a function for delete customer from different tables in
> single database.
>
> i want rollback..
>
> my question:
>where i need to place rollback
OK.. i created a function for delete customer from different tables in
single database.
i want rollback..
my question:
where i need to place rollback ,with in a function
along with deletion statements..? or after run the function ..?
i do not need commit..
please let me kno
On 08/27/2014 11:59 AM, Ramesh T wrote:
In oracle I ran the deletion script to clean up the particular database
using custid.custid is the parameter .&&1 is used in the oracle Inthe
same way tried but $1 not possible ?but using function is possible is
their any problem with fun to Clean the data
Hi
psql variables has different format and its is not directly related to psql
options. But you can do:
[pavel@localhost ~]$ psql postgres --set=myproname=upper
psql (9.5devel)
Type "help" for help.
postgres=# select proname, prosrc from pg_proc where proname = :'myproname';
proname | prosrc
On 8/27/2014 11:59 AM, Ramesh T wrote:
In oracle I ran the deletion script to clean up the particular
database using custid.custid is the parameter .&&1 is used in the
oracle Inthe same way tried but $1 not possible ?but using function is
possible is their any problem with fun to Clean the da
In oracle I ran the deletion script to clean up the particular database
using custid.custid is the parameter .&&1 is used in the oracle Inthe same
way tried but $1 not possible ?but using function is possible is their any
problem with fun to Clean the database I have 100 statements in script ...
On
Ramesh T wrote
> Hi,
> I have deletion script to delete particular cust from
> database.I was
> saved a file name with custde.sql.i need to run from command line like
> putty tool..But have a problem
>
> example :
>
> delete from part where part.custid=$1;
>
> when i ran custde.sql f
On 08/27/2014 08:24 AM, Ramesh T wrote:
any help...
Honestly, this is basic programming/scripting. I would suggest picking
up an introductory programming book to get the basics down.
In the meantime, you have used a parameter variable ($1) with out
actually supplying a parameter. So Postgres
Hello all,
I just reproduced the same phenomenon on my installation (PostgreSQL
7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66) and it seems
to me that maybe the index is not correctly actualized while inserting
the record? It seems that any (!) update on blah (before executing the
dele
25 matches
Mail list logo
