Re: [HACKERS] PROPOSAL: Fast temporary tables

2016-03-01 Thread Atri Sharma
On Tue, Mar 1, 2016 at 8:55 PM, Aleksander Alekseev < a.aleks...@postgrespro.ru> wrote: > Hello > > There are applications that create and delete a lot of temporary > tables. Currently PostgreSQL doesn't handle such a use case well. > Consider the following benchmark/example. > > FWIW, I and Pavel

Re: [HACKERS] PROPOSAL: Fast temporary tables

2016-03-01 Thread Atri Sharma
> > > > I think you have no concept how invasive that would be. Tables not > represented in the catalogs would be a disaster, because *every single > part of the backend* would have to be modified to deal with them as > a distinct code path --- parser, planner, executor, loads and loads > of utili

Re: [HACKERS] PROPOSAL: Fast temporary tables

2016-03-01 Thread Atri Sharma
On Tue, Mar 1, 2016 at 9:30 PM, Robert Haas wrote: > On Tue, Mar 1, 2016 at 10:52 AM, Tom Lane wrote: > > Aleksander Alekseev writes: > >> There are applications that create and delete a lot of temporary > >> tables. Currently PostgreSQL doesn't handle such a use case well. > > > Yeah, I have a

Re: [HACKERS] 2016-01 Commitfest

2016-01-18 Thread Atri Sharma
On Mon, Jan 18, 2016 at 11:05 PM, Alvaro Herrera wrote: > Two weeks into the commitfest, things have moved a bit: > > Needs review: 53. > Waiting on Author: 20. > Ready for Committer: 10. > Committed: 16. > Total: 99. https://commitfest.postgresql.org/8/ > > We have two committed

Re: [HACKERS] about google summer of code 2016

2016-02-18 Thread Atri Sharma
On 19 Feb 2016 8:30 am, "Chapman Flack" wrote: > > On 02/18/16 19:35, Amit Langote wrote: > > > Apparently, the deadline is: February 20, 2016 at 04:00 (+0900 UTC) > > > > https://summerofcode.withgoogle.com/ > > For anybody finding that web site as anti-navigable as I did, here > are more direct

Re: [HACKERS] IMPORT FOREIGN SCHEMA statement

2014-06-15 Thread Atri Sharma
On Mon, Jun 16, 2014 at 11:28 AM, Michael Paquier wrote: > On Mon, May 26, 2014 at 6:23 AM, Ronan Dunklau > wrote: > > Le dimanche 25 mai 2014 12:41:18 David Fetter a écrit : > >> On Fri, May 23, 2014 at 10:08:06PM +0200, Ronan Dunklau wrote: > >> > Hello, > >> > > >> > Since my last proposal di

Re: [HACKERS] bad estimation together with large work_mem generates terrible slow hash joins

2014-07-03 Thread Atri Sharma
On Tue, Jul 1, 2014 at 4:54 AM, Tomas Vondra wrote: > On 30.6.2014 23:12, Tomas Vondra wrote: > > Hi, > > > > attached is v5 of the patch. The main change is that scaling the number > > of buckets is done only once, after the initial hash table is build. The > > main advantage of this is lower pr

Re: [HACKERS] tweaking NTUP_PER_BUCKET

2014-07-03 Thread Atri Sharma
On Thu, Jul 3, 2014 at 11:40 PM, Stephen Frost wrote: > Tomas, > > * Tomas Vondra (t...@fuzzy.cz) wrote: > > However it's likely there are queries where this may not be the case, > > i.e. where rebuilding the hash table is not worth it. Let me know if you > > can construct such query (I wasn't).

Re: [HACKERS] how to skip building certain paths in path tree

2014-07-21 Thread Atri Sharma
On Tue, Jul 22, 2014 at 10:53 AM, Rajmohan C wrote: > How do I modify PostgreSQL 9.3 source to skip certain join combinations > (skip building certain paths in path tree) by checking some condition > have a look at joinpaths.c

Re: [HACKERS] Shared Data Structure b/w clients

2014-07-22 Thread Atri Sharma
On Tuesday, July 22, 2014, Rohit Goyal wrote: > Hi All, > > I am working on postgresql code and having some problem. :) > > I need to create shared data structure, so that different client and > connection can update and share the state of those data structures in > memory. I planned to use top m

Re: [HACKERS] 9.5: Memory-bounded HashAgg

2014-08-14 Thread Atri Sharma
On Thursday, August 14, 2014, Jeff Davis wrote: > On Thu, 2014-08-14 at 10:06 -0400, Tom Lane wrote: > > If you're following the HashJoin model, then what you do is the same > thing > > it does: you write the input tuple back out to the pending batch file for > > the hash partition that now conta

Re: [HACKERS] 9.5: Memory-bounded HashAgg

2014-08-14 Thread Atri Sharma
On Thu, Aug 14, 2014 at 10:21 PM, Tomas Vondra wrote: > On 14 Srpen 2014, 18:02, Atri Sharma wrote: > > On Thursday, August 14, 2014, Jeff Davis wrote: > > > >> On Thu, 2014-08-14 at 10:06 -0400, Tom Lane wrote: > >> > If you're following the Has

Re: [HACKERS] Updatable view?

2015-07-30 Thread Atri Sharma
On 31 Jul 2015 11:59, "Tatsuo Ishii" wrote: > > > On 31 Jul 2015 10:15, "Tatsuo Ishii" wrote: > >> > >> > I think it would be nice to have... but not to the point of working on > >> > it myself. > >> > > >> > Might be worth an email to -general to see how many people have > >> > immediate use for

Re: [HACKERS] Commitfest remaining "Needs Review" items

2015-08-10 Thread Atri Sharma
> > * Unique Joins >> > > Still needs to be reviewed. Any volunteers? > > > Can take this one up, if its within my limits.

Re: [HACKERS] count_nulls(VARIADIC "any")

2015-08-13 Thread Atri Sharma
On Thu, Aug 13, 2015 at 12:55 PM, Pavel Stehule wrote: > > > 2015-08-13 9:21 GMT+02:00 Marko Tiikkaja : > >> On 8/13/15 9:18 AM, Shulgin, Oleksandr wrote: >> >>> nnulls() >>> >> >> I think I'd prefer num_nulls() over that. >> > > can be > > what about similar twin function num_nonulls()? > > +1

Re: [HACKERS] Questionable coding in orderedsetaggs.c

2014-01-25 Thread Atri Sharma
On Sunday, January 26, 2014, Tom Lane wrote: > Jeremy Harris > writes: > > In ordered_set_startup() sorts are initialised in non-randomAccess mode > > (tuplesort_begin_heap() and ~datum(), last argument). > > > The use of tuplesort_skip_tuples() feels very like a random access to > > me. I think

Re: [HACKERS] A better way than tweaking NTUP_PER_BUCKET

2014-01-26 Thread Atri Sharma
Sent from my iPad > On 26-Jan-2014, at 4:38, Simon Riggs wrote: > >> On 25 January 2014 22:33, Stephen Frost wrote: >> >> * Tom Lane (t...@sss.pgh.pa.us) wrote: > >>> AFAICT, there was no consensus in this thread on what to do, which >>> probably has something to do with the lack of concret

Re: [HACKERS] inherit support for foreign tables

2014-01-27 Thread Atri Sharma
Sent from my iPad > On 27-Jan-2014, at 21:03, David Fetter wrote: > >> On Mon, Jan 27, 2014 at 05:06:19PM +0900, Etsuro Fujita wrote: >> Hi Hanada-san, >> >> While still reviwing this patch, I feel this patch has given enough >> consideration to interactions with other commands, but found the

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-01-28 Thread Atri Sharma
On Tue, Jan 28, 2014 at 11:04 PM, Thom Brown wrote: > Hi all, > > Application to Google Summer of Code 2014 can be made as of next > Monday (3rd Feb), and then there will be a 12 day window in which to > submit an application. > > I'd like to gauge interest from both mentors and students as to >

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-01-28 Thread Atri Sharma
On Tue, Jan 28, 2014 at 11:16 PM, Atri Sharma wrote: > > > On Tue, Jan 28, 2014 at 11:04 PM, Thom Brown wrote: > >> Hi all, >> >> Application to Google Summer of Code 2014 can be made as of next >> Monday (3rd Feb), and then there will be a 12 day window

Re: [HACKERS] inherit support for foreign tables

2014-01-29 Thread Atri Sharma
Sent from my iPad On 28-Jan-2014, at 10:04, Kouhei Kaigai wrote: >>> I wonder what shall be the cases when foreign table is on a server which >> does not support *all* SQL features. >>> >>> Does a FDW need to have the possible inherit options mentioned in its >> documentation for this patch?

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:01 PM, Ronan Dunklau wrote: > Hello, > > The SQL-MED specification defines the IMPORT FOREIGN SCHEMA statement. > > This adds discoverability to foreign servers. The structure of the > statement > as I understand it is simple enough: > > IMPORT FOREIGN SCHEMA remote_schem

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:39 PM, Ronan Dunklau wrote: > > I havent had a look at the patch yet since I dont have a nice editor > right > > now, but how do you handle inter operability between datatypes? > > Specifically, how do you handle those datatypes which have a different > name > > from the

Re: [HACKERS] Proposal: IMPORT FOREIGN SCHEMA statement.

2014-02-21 Thread Atri Sharma
On Fri, Feb 21, 2014 at 4:56 PM, Ronan Dunklau wrote: > Le vendredi 21 février 2014 16:45:20 Atri Sharma a écrit : > > On Fri, Feb 21, 2014 at 4:39 PM, Ronan Dunklau > wrote: > > > > I havent had a look at the patch yet since I dont have a nice editor > > > >

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-02-25 Thread Atri Sharma
Awesome. I can be an assistant mentor for this one is possible or I could mentor some other project. On Tuesday, February 25, 2014, Andreas 'ads' Scherbaum < adsm...@wars-nicht.de> wrote: > > Hi, > > On 01/28/2014 06:46 PM, Atri Sharma wrote: > >> On Tue,

Re: [HACKERS] ALTER TABLE lock strength reduction patch is unsafe

2014-03-04 Thread Atri Sharma
> > Good points. > > In most cases, DDL is applied manually after careful thought, so > people seldom dump at the same time they upgrade the database. This is > especially true for pg_dump since it captures the logical definition > of tables. So most people will be happy with the default locking, b

Re: [HACKERS] ALTER TABLE lock strength reduction patch is unsafe

2014-03-04 Thread Atri Sharma
> > If its not the case, the user should be more careful about when he is > > scheduling backups to so that they dont conflict with DDL changes. > > That is most certainly the wise choice. > > > I am not too comfortable with exposing the locking type to the user. That > > may be just me though. > >

Re: [HACKERS] ALTER TABLE lock strength reduction patch is unsafe

2014-03-04 Thread Atri Sharma
I'd really like to see us find a way to apply some version of this > patch. I was in favor of the concept 3 years ago when we did this the > first time, and I've subsequently done quite a bit of work (viz., MVCC > catalog snapshots) to eliminate the main objection that was raised at > that time.

Re: [HACKERS] ALTER TABLE lock strength reduction patch is unsafe

2014-03-04 Thread Atri Sharma
On Tue, Mar 4, 2014 at 8:19 PM, Stephen Frost wrote: > * Atri Sharma (atri.j...@gmail.com) wrote: > > If its not the case, the user should be more careful about when he is > > scheduling backups to so that they dont conflict with DDL changes. > > I'm not following this

Re: [HACKERS] ALTER TABLE lock strength reduction patch is unsafe

2014-03-04 Thread Atri Sharma
On Tue, Mar 4, 2014 at 10:20 PM, Stephen Frost wrote: > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > Stephen Frost writes: > > > I don't have too much of an issue with the above, but I would like to > > > have us figure out a solution to the deadlock problem with parallel > > > pg_dump. The issue

Re: [HACKERS] Selection of join algorithm.

2014-03-08 Thread Atri Sharma
On Saturday, March 8, 2014, Ishaya Bhatt wrote: > Hi, > > I am trying to analyze join performance. But I see that even for a table > having 100,000 rows and join attribute as primary key, postgres always > performs hash join. > > Can anyone please tell me under which conditions merge join or nest

Re: [HACKERS] Why is AccessShareLock held until end of transaction?

2014-03-11 Thread Atri Sharma
On Tue, Mar 11, 2014 at 10:56 PM, Simon Riggs wrote: > On 11 March 2014 03:41, Tom Lane wrote: > > Joe Conway writes: > >> I am probably missing something obvious, but why does the > >> AccessShareLock remain held on a table after a SELECT statement is > >> complete when in a transaction block?

Re: [HACKERS] Why is AccessShareLock held until end of transaction?

2014-03-11 Thread Atri Sharma
On Tue, Mar 11, 2014 at 11:07 PM, Simon Riggs wrote: > On 11 March 2014 17:29, Atri Sharma wrote: > > > > > > > > On Tue, Mar 11, 2014 at 10:56 PM, Simon Riggs > wrote: > >> > >> On 11 March 2014 03:41, Tom Lane wrote: > >> > Joe Con

[HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Hi all, I was experimenting with the idea of moving hot buffer pages from the buffer pool to heap, thus allowing for normal removal of the hot buffer page from the buffer pool and freeing the corresponding buffer pool slot. This shouldnt be too hard to implement, we just need to keep track of the

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:14, Tom Lane wrote: > Atri Sharma writes: >> I was experimenting with the idea of moving hot buffer pages from the >> buffer pool to heap, thus allowing for normal removal of the hot >> buffer page from the buffer pool and free

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:24, Jeff Janes wrote: > On Mon, Aug 5, 2013 at 12:36 PM, Atri Sharma wrote: >> Hi all, >> >> I was experimenting with the idea of moving hot buffer pages from the >> buffer pool to heap, > > Which heap do you mean her

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:57, Tom Lane wrote: > Atri Sharma writes: >> Just experimenting though.I was thinking of scenarios where a page is pinned >> for long period of time.My concern was that it would lead to blocking of a >> buffer pool slot for that

Re: [HACKERS] StrategyGetBuffer optimization, take 2

2013-08-07 Thread Atri Sharma
On Wed, Aug 7, 2013 at 10:37 PM, Andres Freund wrote: > On 2013-08-07 09:40:24 -0500, Merlin Moncure wrote: >> > I don't think the unlocked increment of nextVictimBuffer is a good idea >> > though. nextVictimBuffer jumping over NBuffers under concurrency seems >> > like a recipe for disaster to me

Re: [HACKERS] median and percentile function implementation

2013-08-26 Thread Atri Sharma
On Mon, Aug 26, 2013 at 10:15 PM, Pavel Stehule wrote: > Hello > > very nice! I tested it and works very well. > > And I looking for implementation in core. > > Two notes: > > * should to support string_agg and array_agg > > Regards > > Pavel > > > > 2013/8/26 Vik Fearing >> >> On 08/26/2013 02:3

Re: [HACKERS] Valgrind Memcheck support

2013-08-27 Thread Atri Sharma
Sent from my iPad On 27-Aug-2013, at 19:44, Andres Freund wrote: > Hi Noah, > > On 2013-06-09 17:25:59 -0400, Noah Misch wrote: >> *** a/src/backend/tcop/postgres.c >> --- b/src/backend/tcop/postgres.c >> *** >> *** 69,74 >> --- 69,75 >> #include "tcop/tcopprot.h" >> #

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-03 Thread Atri Sharma
On Wed, Sep 4, 2013 at 6:40 AM, Satoshi Nagayasu wrote: > Hi, > > I'm considering overhauling pgstat.stat, and would like to know how many > people are interested in this topic. > > As you may know, this file could be handreds of MB in size, because > pgstat.stat holds all access statistics in eac

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-03 Thread Atri Sharma
Sent from my iPad On 04-Sep-2013, at 10:54, Satoshi Nagayasu wrote: > Hi, > > (2013/09/04 12:52), Atri Sharma wrote: >> On Wed, Sep 4, 2013 at 6:40 AM, Satoshi Nagayasu wrote: >>> Hi, >>> >>> I'm considering overhauling pgstat.stat, and would

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-04 Thread Atri Sharma
Sent from my iPad On 04-Sep-2013, at 15:39, Satoshi Nagayasu wrote: > (2013/09/04 15:23), Atri Sharma wrote: >> >> >> Sent from my iPad >> >> On 04-Sep-2013, at 10:54, Satoshi Nagayasu wrote: >> >>> Hi, >>> >>> (2013/09

Re: [HACKERS] Re: Proposal/design feedback needed: WITHIN GROUP (sql standard ordered set aggregate functions)

2013-09-04 Thread Atri Sharma
Sent from my iPad On 04-Sep-2013, at 21:38, Peter Eisentraut wrote: > On 7/19/13 11:59 AM, Atri Sharma wrote: >> Hi all, >> >> This is our current work-in-progress patch for WITHIN GROUP. > > This patch needs to be rebased. > This version of patch is quite old

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-04 Thread Atri Sharma
Sent from my iPad On 05-Sep-2013, at 8:58, Satoshi Nagayasu wrote: > (2013/09/05 3:59), Alvaro Herrera wrote: >> Tomas Vondra wrote: >> >>> My idea was to keep the per-database stats, but allow some sort of >>> "random" access - updating / deleting the records in place, adding >>> records etc

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-05 Thread Atri Sharma
On Thu, Sep 5, 2013 at 10:59 AM, Alvaro Herrera wrote: > Satoshi Nagayasu wrote: > >> But, for now, I think we should have a real index for the >> statistics data because we already have several index storages, >> and it will allow us to minimize read/write operations. >> >> BTW, what kind of inde

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-07 Thread Atri Sharma
Sent from my iPad On 08-Sep-2013, at 4:27, Tomas Vondra wrote: > On 5.9.2013 09:36, Atri Sharma wrote: >> On Thu, Sep 5, 2013 at 10:59 AM, Alvaro Herrera >> wrote: >>> Satoshi Nagayasu wrote: >>> >>>> But, for now, I think we should have a rea

Re: [HACKERS] [rfc] overhauling pgstat.stat

2013-09-07 Thread Atri Sharma
Sent from my iPad On 08-Sep-2013, at 4:27, Tomas Vondra wrote: > On 5.9.2013 09:36, Atri Sharma wrote: >> On Thu, Sep 5, 2013 at 10:59 AM, Alvaro Herrera >> wrote: >>> Satoshi Nagayasu wrote: >>> >>>> But, for now, I think we should have a rea

Re: [HACKERS] Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

2013-10-07 Thread Atri Sharma
Sent from my iPad > On 07-Oct-2013, at 4:11, Tomas Vondra wrote: > >> On 6.10.2013 20:37, Tomáš Janoušek wrote: >> Hi, >> >>> On Sat, Oct 05, 2013 at 08:22:54PM +0200, Tomas Vondra wrote: >>> I'm on 64-bit architecture and the example works with int32, which means >>> the sizes should be abou

Re: [HACKERS] Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

2013-10-07 Thread Atri Sharma
Hi Tomas, >> Consider the aspects associated with open addressing.Open addressing >> can quickly lead to growth in the main table.Also, chaining is a much >> cleaner way of collision resolution,IMHO. > > What do you mean by "growth in the main table"? Sorry, I should have been more verbose. AFA

Re: [HACKERS] Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

2013-10-08 Thread Atri Sharma
Sent from my iPad > On 08-Oct-2013, at 10:41, Claudio Freire wrote: > > On Tue, Oct 8, 2013 at 1:23 AM, Atri Sharma wrote: >>>> Consider the aspects associated with open addressing.Open addressing >>>> can quickly lead to growth in the main table.Also, chain

Re: [HACKERS] Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

2013-10-08 Thread Atri Sharma
Sent from my iPad > > However I'm unable to make it at least comparable to chaining. The trick > is that the hash table performs reasonably only until it's ~ 65-70% full, > it gets really slow after that. So to maintain performance comparable to > chaining, I'd have to keep the table below this

Re: [HACKERS] Re: custom hash-based COUNT(DISTINCT) aggregate - unexpectedly high memory consumption

2013-10-08 Thread Atri Sharma
On Tue, Oct 8, 2013 at 4:15 PM, Tomas Vondra wrote: > On 8 Říjen 2013, 11:42, Atri Sharma wrote: >>> >>> I've made some significant improvements in the chaining version (in the >>> master branch), now getting about the memory consumption I've estimated. &

Re: [HACKERS] stats for network traffic WIP

2013-10-23 Thread Atri Sharma
On Thu, Oct 24, 2013 at 12:23 AM, Mike Blackwell wrote: > Sounds good. I personally don't have any interest in log file i/o counters, > but that's just me. I wonder if stats collector counters might be useful... > I seem to recall an effort to improve that area. Maybe not enough use to > take t

Re: [HACKERS] stats for network traffic WIP

2013-10-23 Thread Atri Sharma
On Thu, Oct 24, 2013 at 12:30 AM, Mike Blackwell wrote: > > On Wed, Oct 23, 2013 at 1:58 PM, Atri Sharma wrote: > >> >> IMO, the idea is pretty good. Its just that we need to do some wide >> spectrum performance testing. Thats only my thought though. > > >

Re: [HACKERS] Save Hash Indexes

2013-11-01 Thread Atri Sharma
On Friday, November 1, 2013, k...@rice.edu wrote: > On Fri, Nov 01, 2013 at 01:31:10PM +, Dimitri Fontaine wrote: > > Hi, > > > > Here's an idea: when a user ask for an Hash Index transparently build a > > BTree index over an hash function instead. > > > > Advantages: > > > > - it works > >

Re: [HACKERS] Feature request: Optimizer improvement

2013-11-01 Thread Atri Sharma
On Friday, November 1, 2013, Jim Nasby wrote: > On Oct 31, 2013, at 2:57 PM, Kevin Grittner > > > wrote: > > Joe Love 'j...@primoweb.com');>> wrote: > > In postgres 9.2 I have a function that is relatively expensive. > > > What did you specify in the COST clause on the CREATE FUNCTION > statemen

Re: Handle LIMIT/OFFSET before select clause (was: [HACKERS] Feature request: optimizer improvement)

2013-11-02 Thread Atri Sharma
On Sat, Nov 2, 2013 at 2:00 AM, Tom Lane wrote: > Jim Nasby writes: >> On Oct 31, 2013, at 11:04 AM, Joe Love wrote: >>> In postgres 9.2 I have a function that is relatively expensive. When I >>> write a query such as: >>> >>> select expensive_function(o.id),o.* from offeirng o where valid='Y'

Re: Handle LIMIT/OFFSET before select clause (was: [HACKERS] Feature request: optimizer improvement)

2013-11-05 Thread Atri Sharma
On Tue, Nov 5, 2013 at 11:55 PM, Tom Lane wrote: > Joe Love writes: >> I'm wondering what type of index would work for this as it is a volatile >> function. Not knowing how PGs optimizer runs, I'm at a loss as to why this >> wouldn't be possible or worth doing. It seems to me that all functions i

Re: [HACKERS] Fwd: Test of Algorithm || Indexing Scheme

2013-11-11 Thread Atri Sharma
On Tue, Nov 12, 2013 at 11:53 AM, Craig Ringer wrote: > On 11/12/2013 03:26 AM, Rohit Goyal wrote: >> Hi, >> >> Actually, >> >> I want to test an algorithm in which I will use store tuple_id in some >> other data structure and value of the key of index will contain some >> random created by me. Co

Re: [HACKERS] Proposal: "Causal reads" mode for load balancing reads without stale data

2015-11-11 Thread Atri Sharma
> I'm thinking the client should get some kind of a token back from the commit, and it could use the token on the standby, to wait for that commit to be applied. The token could be just the XID, or the LSN of the commit record. Or the application could generate the token and pass it to the server i

[HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
Hi All, I am Atri Sharma.I am a C developer with experience in database designing and database management systems.I have worked with MySql,Oracle and other database systems.I have designed databases for various projects as well. I would be interested in developing the column reordering project by

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
n the idea. Atri -Original Message- From: Andrew Dunstan [mailto:and...@dunslane.net] Sent: 17 March 2012 21:30 To: Atri Sharma Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On 03/17/2012 04:39 AM, Atri Sharma wrote: > Hi

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
, changes in the graph will be done and minimal spanning tree would be recomputed. Atri -Original Message- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: 17 March 2012 22:43 To: 'Andrew Dunstan' Cc: 'pgsql-hackers@postgresql.org' Subject: RE: [HACKERS] Regardi

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
:17 To: Atri Sharma Cc: Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 Excerpts from Atri Sharma's message of sáb mar 17 05:39:10 -0300 2012: > Hi All, > > I am Atri Sharma.I am a C developer with experience in database > designing and da

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
[mailto:alvhe...@commandprompt.com] Sent: 18 March 2012 00:34 To: Atri Sharma Cc: Pg Hackers Subject: RE: [HACKERS] Regarding column reordering project for GSoc 2012 Excerpts from Atri Sharma's message of sáb mar 17 15:48:13 -0300 2012: > > HI Alvaro, > I did send a complete description

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
Hi Dave, I believe,with the ALTER command,we plan to give the user power to modify ordering . Don't we? Atri From: Dave Page [mailto:dp...@pgadmin.org] Sent: 18 March 2012 00:46 To: Atri Sharma Cc: Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering pr

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
-Original Message- From: Daniel Farina [mailto:dan...@heroku.com] Sent: 18 March 2012 06:30 To: Andrew Dunstan Cc: Dave Page; Atri Sharma; Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Sat, Mar 17, 2012 at 1:48 PM, Andrew Dunstan

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
-Original Message- From: jcasa...@systemguards.com.ec [mailto:jcasa...@systemguards.com.ec] On Behalf Of Jaime Casanova Sent: 18 March 2012 01:04 To: Atri Sharma Cc: Dave Page; Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Sat

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Atri Sharma
On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera wrote: > > Excerpts from Atri Sharma's message of dom mar 18 01:05:23 -0300 2012: > >> I am understanding the scenario now. I will take a little of your time to >> modify my original idea: >> >> The "middle layer" still exists, but NOT on the indivi

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Atri Sharma
On Tue, Mar 20, 2012 at 12:08 AM, Atri Sharma wrote: > On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera > wrote: >> >> Excerpts from Atri Sharma's message of dom mar 18 01:05:23 -0300 2012: >> >>> I am understanding the scenario now. I will take a little

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Claes Jakobsson [mailto:cl...@versed.se] Sent: 20 March 2012 14:40 To: Merlin Moncure Cc: Heikki Linnakangas; Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 03:15 To: Heikki Linnakangas Cc: Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Mon, Mar

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com] Sent: 20 March 2012 17:39 To: Claes Jakobsson Cc: Merlin Moncure; Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 20:52 To: Atri Sharma Cc: Heikki Linnakangas; Alvaro Herrera; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 22:50 To: Atri Sharma Cc: Heikki Linnakangas; Alvaro Herrera; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
On Wed, Mar 21, 2012 at 12:42 AM, Merlin Moncure wrote: > On Tue, Mar 20, 2012 at 12:34 PM, Atri Sharma wrote: >> >> >> -Original Message- >> From: Merlin Moncure [mailto:mmonc...@gmail.com] >> Sent: 20 March 2012 22:50 >> To: Atri Sharma >> C

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-21 Thread Atri Sharma
-Original Message- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: 22 March 2012 09:20 To: 'Atri Sharma' Subject: RE: [HACKERS] Regarding column reordering project for GSoc 2012 -Original Message----- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: 20 March

[HACKERS] Regarding GSoc Application

2012-04-07 Thread Atri Sharma
Hi All, I submitted a GSoc application yesterday. Please review it and let me know if anyone needs any clarifications. Atri

[HACKERS] Regarding GSoc proposal

2012-04-09 Thread Atri Sharma
Hi all, I submitted a proposal for GSoc 2012.Please review it and let me know your comments. The link is: https://google-melange.appspot.com/gsoc/proposal/review/google/gsoc2012/atrisharma/1001 Atri -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgres

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-09 Thread Atri Sharma
On Mon, Apr 9, 2012 at 10:15 PM, Andrew Dunstan wrote: > > > On 04/09/2012 12:14 PM, Dave Cramer wrote: >> >> >> So I'm confused, once they link a file to an FDW can't you just read >> it with an normal select ? >> >> What additional functionality will this provide ? >> > > > > I'm confused about

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-09 Thread Atri Sharma
On Mon, Apr 9, 2012 at 11:40 PM, Merlin Moncure wrote: > On Mon, Apr 9, 2012 at 12:25 PM, Atri Sharma wrote: >> On Mon, Apr 9, 2012 at 10:15 PM, Andrew Dunstan wrote: >>> On 04/09/2012 12:14 PM, Dave Cramer wrote: >>>> So I'm confused, once they link a file to

Re: [HACKERS] Regarding GSoc proposal

2012-04-10 Thread Atri Sharma
On Tue, Apr 10, 2012 at 5:38 PM, Albe Laurenz wrote: > Atri Sharma wrote: >> I submitted a proposal for GSoc 2012.Please review it and let me know >> your comments. >> >> The link is: >> >> > https://google-melange.appspot.com/gsoc/proposal/review/goog

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-10 Thread Atri Sharma
On Tue, Apr 10, 2012 at 8:55 PM, Tom Lane wrote: > Merlin Moncure writes: >> ...  We have to invoke java and there >> are two basic ways to tie into the java runtime:  one is to jump >> through SPI via the SQL executor. The other is JNI into the pl/java >> jvm which I think you were hinting was t

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-10 Thread Atri Sharma
>> I agree that JNI isn't required -- we're going to >> have to study the pl/java system a bit to determine the best way to >> hook in. This could end up getting us into the 'biting of more than >> can chew' territory admittedly, but Atri is enthusiastic and wants to >> give it a go. > >Well. may

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-10 Thread Atri Sharma
> >I think Multicorn is a good example, which invokes Python from FDW >routines though it is not using PL/Python. > >http://multicorn.org/ > > Hi Hitoshi, Thanks for the link. You mean,I should try to build something like Multicorn for Java? Atri -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-11 Thread Atri Sharma
Hi all, In continuation to the discussion regarding my JDBC wrapping FDW,I have been talking to members of the community and I have two approaches on which I would request your suggestions and opinions: >I think we are back on the initial approach I proposed(hooking directly into the JVM and ex

Re: [HACKERS] [JDBC] Regarding GSoc Application

2012-04-11 Thread Atri Sharma
On Tue, Apr 10, 2012 at 10:41 PM, Atri Sharma wrote: >>>Well. maybe I spoke too soon...JNI is probably the best route. Since >>>SPI is off the table, all we're really pulling in from pl/java is the >>>(non-trivial) proper installation of a jvm into a postgres pr

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
Sent from my iPad On 17-May-2013, at 6:11, Liming Hu wrote: > Hi, > > I am studying your levenshtein edit distance contribution in Postgresql. > > Can we add Levenshtein-Damerau edit distance since it is used in > spelling checker > instead of levenshtein edit distance? > > Levenshtein-Dame

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
On Fri, May 17, 2013 at 8:51 PM, Liming Hu wrote: > Hi Atri, > > Thanks for the quick response. > > levenshtein edit distance defines operations of: insertion, deletion, > modification. > Levenshtein-Damerau edit distance defines operations of: insertion, > deletion, modification > and transposit

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
On Fri, May 17, 2013 at 8:56 PM, Liming Hu wrote: > On 5/17/2013 8:23 AM, Atri Sharma wrote: >> >> On Fri, May 17, 2013 at 8:51 PM, Liming Hu wrote: >>> >>> Hi Atri, >>> >>> Thanks for the quick response. >>> >>>

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
On Fri, May 17, 2013 at 9:29 PM, Alvaro Herrera wrote: > Liming Hu escribió: >> Hi Atri, >> >> I also talked to the author of fuzzystrmatch, he also thinks it is a >> good feature. > > Yeah, I heard our fuzzystrmatch module being talked down a decade ago > for not considering transpositions, so +1

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote: > On 5/17/2013 12:39 PM, Liming Hu wrote: >> >> On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote: Can we add Levenshtein-Damerau edit distance since it is used in spelling checker instead of levenshtein edit distance? >>> >>

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
Sent from my iPad On 18-May-2013, at 10:00, Liming Hu wrote: > On 5/17/2013 9:10 PM, Atri Sharma wrote: >> On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote: >>> On 5/17/2013 12:39 PM, Liming Hu wrote: >>>> On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
Sent from my iPad On 18-May-2013, at 10:41, Liming Hu wrote: > On Fri, May 17, 2013 at 9:39 PM, Atri Sharma wrote: >> >> >> Sent from my iPad >> >> On 18-May-2013, at 10:00, Liming Hu wrote: >> >>> On 5/17/2013 9:10 PM, Atri Sharma wrote:

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
Sent from my iPad On 18-May-2013, at 11:23, Liming Hu wrote: > On Fri, May 17, 2013 at 10:21 PM, Atri Sharma wrote: >> >> >> Sent from my iPad >> >> On 18-May-2013, at 10:41, Liming Hu wrote: >> >>> On Fri, May 17, 2013 at 9:39 PM, Atri S

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-17 Thread Atri Sharma
Sent from my iPad On 18-May-2013, at 12:07, Liming Hu wrote: > On Fri, May 17, 2013 at 11:13 PM, Atri Sharma wrote: >> >> >> Sent from my iPad >> >> On 18-May-2013, at 11:23, Liming Hu wrote: >> >>> On Fri, May 17, 2013 at 10:21 PM, Atri S

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-18 Thread Atri Sharma
Sent from my iPad On 18-May-2013, at 12:34, Liming Hu wrote: > On Fri, May 17, 2013 at 11:44 PM, Atri Sharma wrote: >> >> >> Sent from my iPad >> >> On 18-May-2013, at 12:07, Liming Hu wrote: >> >>> On Fri, May 17, 2013 at 11:13 PM, Atri S

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-18 Thread Atri Sharma
On Sat, May 18, 2013 at 1:30 PM, Liming Hu wrote: > On 5/18/2013 12:11 AM, Atri Sharma wrote: > > Sent from my iPad > > On 18-May-2013, at 12:34, Liming Hu wrote: > > On Fri, May 17, 2013 at 11:44 PM, Atri Sharma wrote: > > Sent from my iPad > > On 18-May

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-18 Thread Atri Sharma
On Sat, May 18, 2013 at 1:47 PM, Liming Hu wrote: > On 5/18/2013 1:03 AM, Atri Sharma wrote: >> >> On Sat, May 18, 2013 at 1:30 PM, Liming Hu wrote: >>> >>> On 5/18/2013 12:11 AM, Atri Sharma wrote: >>> >>> Sent from my iPad >>> >>

  1   2   3   4   >