> you need installed devel packages
>
>
>
I tried to install these packages (uuid-devel and systemd-unit) but yum can
not locate these packages. I tried to install selinux-policy but I found
out that selinux-policy 3.7.19 is already installed and is the latest
package available in Red Hat repositor
GROUP BY clauses in a normal sql statement and
they seem to use indexes nicely.
Is this being already considered for development?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
On Wed, Oct 23, 2013 at 10:58 PM, Tom Lane wrote:
> Sameer Kumar writes:
> > I am not sure why but my PostgreSQL does not seem to be using indexes for
> > ORDER BY clause or PARTITION BY CLAUSE which I use with windowing
> function.
>
> When the entire contents of the
function.
Another thing regarding work_memory, I have generally seen that windowing
functions expect more amount of memory for sorting compared to
grouping/ordering clauses.
On 24 Oct 2013 10:54, "David Johnston" wrote:
> Sameer Kumar wrote
> > edb=# explain analyze select max(score)
>
>
>
> > Agree that windowing function will return all the rows compared to max
> and
> > group by returing only max rows per group. But even while arriving at the
> > aggregate/sorting windowing function seems to spend more effort than
> group
> > by/order by.
>
> (I'll apologise in advance for p
> Hello,
>
> > > With this index, you will get a different plan like this,
> > >
> > Exactly my point, can we look at making windowing functions
> > smart and make use of available indexes?
>
> I might have guessed..
>
>
> > > Does this satisfies your needs?
> > >
> > Not exactly. If I have missed
I was recently running some tests with huge page tables. I ran them on two
different architectures: x86 and PPC64.
I saw some discussion going on over here so thought of sharing.
I was using 3 Cores, 8GB RAM, 2 LUN for filesystem (1 for dbfiles and 1 for
logfiles) for these tests...
I had dedicat
On Thu, Nov 14, 2013 at 6:51 PM, Kyotaro HORIGUCHI <
horiguchi.kyot...@lab.ntt.co.jp> wrote:
> Hello,
>
> > When I read it again and try to relate, I get your point. Actually true,
> > hashes must always be performed as last option (if that is what you too
> > meant) and if there are few other ope
tmt is passed to CreateTrigger function as an arguement. I am
struggling to understand how the values for various members of trigger are
set and where [which file] calls CreateTrigStmt.
Can someone provide some help on this?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD. *
>
>
> >
> > CreateTrigStmt is passed to CreateTrigger function as an arguement. I am
> > struggling to understand how the values for various members of trigger
> are
> > set and where [which file] calls CreateTrigStmt.
> >
> >
> > Can someone provide some help on this?
>
> I think you need better t
>
>
> I read somewhere that "the best editor is the
> one you master" (1) :)
> 1: http://www.postgresql.org/message-id/m2wrs6giyp@hi-media.com
>
>
Thanks, I am using eclipse now.
Any comments about the utility of this feature? Or is it just me who thinks
this can be useful? I think users/dev
I have been finally able to get the right set of files. I going with below
approach:
1) Add a new column in pg_trigger called tgiscascaded
2) Change pg_trigger.h for this
3) Made changes in trigger.c to insert this values
4) Corresponding changes made in
- reltrigger.h
One scenario where I can forsee an issue is when someone uses the tablename
with-in the trigger function on which the trigger was fired. I am not sure
how and what issue might crop up but this will be one of my test cases.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com
https://github.com/vmware/pg_rewind
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350 <%2B65%208110%200350>* T: +65 6438 3504 | www.ashnik.com
*[image: icons]*
[image: Email patch] <htt
> This discussion is not really adapted on hackers as pg_rewind is not
> included in Postgres core code. Please let's discuss your proposal there.
Got it. But given the above, can we keep this discussion thread here?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASH
On Wed, Jan 14, 2015 at 2:11 AM, Heikki Linnakangas wrote:
> On 01/13/2015 12:11 PM, Vladimir Borodin wrote:
>
>>
>> 05 янв. 2015 г., в 18:15, Vladimir Borodin написал(а):
>>
>> Hi all.
>>>
>>> I have a simple script for planned switchover of PostgreSQL (9.3 and
>>> 9.4) master to one of its re
from that you want this check, I suppose
> you're not guaranteed not to have trouble or not trusting the
> mechanism itself.
>
> Right! I was coming from the point that if master has shutdown gracefully
then you don't really need to worry about ensuring with such checks on
St
17 matches
Mail list logo
