mments, please send to pgday-asia
[at] googlegroups.co.jp
Regards,
--
Satoshi Nagayasu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2010/10/12 8:46, Carlos Mennens wrote:
Just wondering how you guys feel about NoSQL and I just wanted to
share the following article...
http://www.linuxjournal.com/article/10770
Looking to read your feedback and / or opinions.
Seems a nice article. I like it. :)
I think "NoSQL is a new im
Hi Gavin,
On 2010/11/04, at 17:58, Gavin Burrows wrote:
> I'm sure you have had this question many times before but I feel as though I
> have genuinely exhausted all of my option and followed all the advise I can
> find online.
>
> During installation of Postgresql at the time when it tries t
Hi Ben,
On 2010/12/22 7:46, Ben Carbery wrote:
FYI, not looking for a detailed how to here.. I have read the manual twice and
just can't figure which sections are relevant. The manual seems to be trying to
cover all uses simultaneously which is always going to get confusing :) For
example do
On 2010/12/26, at 21:35, sunpeng wrote:
> so the writing speed on disk of pc is much faster than laptop, why the update
> sql command is much slower than my laptop? what's the reason causing such
> decrease?
Are those PostgreSQL versions and/or configurations completely same?
How about shared_b
Hi all,
I'm looking for some tricky way for tsearch query.
Now, I know when a tsvector column has an array ('a', 'b', 'c'),
tsquery ('a&c') hits the row.
But I want to search rows with considering the order of tsvector
elements.
I want to hit a row when I use 'a&b' or 'b&c' in a tsquery,
but no
r I can use GROUP BY with it.
Do you have any experience or recommendation about visual query builder
for PostgreSQL?
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
te your SQL. It does allow for group by's, counts, etc.
Yeah, I will also look at MS Access as a query builder, although I'm not
familiar with the software so far.
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing lis
(2013/02/09 0:41), Adrian Klaver wrote:
On 02/08/2013 07:33 AM, Kevin Grittner wrote:
Satoshi Nagayasu wrote:
Of course, I can write ad-hoc queries by myself. However, I'd
like to allow non-tech people to issue ad-hoc queries with using
some visual query builder.
You should probably t
S) someday. :)
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ce which can be shared?
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e mdextend() in src/backend/storage/smgr/md.c.
That's the code which deals with segment files on extending a table,
and RELSEG_SIZE defines the segment size, 1GB by default.
Regards,
--
Satoshi Nagayasu
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing
thought I'd try asking here before I
started to patch Postgres :)
See xlogdump if you use 9.2 or earlier.
https://github.com/snaga/xlogdump
If you're going to use 9.3, you can find pg_xlogdump in the contrib.
http://www.postgresql.org/docs/devel/static/pgxlogdump.html
Regards,
--
Satosh
Hi,
2011/05/17 14:31, Adarsh Sharma wrote:
Rick Genter wrote:
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
Dear all,
I need to research on Memcache in the next few days.
What I want to know is it worth to have memcahed enable in our Mysql/ Postgres
Production Servers.
We have databa
Hi,
2011/5/18 Tatsuo Ishii :
>> How do you handle statements that rely on current_timestamp, random(),
>> etc? What about if their reliance is via a function? Is that just an
>> understood limitation of the cache, that it'll cache even queries that
>> don't really make sense to cache?
>
> Probably
Hi all,
I'm looking into some ecpg part of the official manual,
and I have found some strange things.
I'm now investigating SQLCODE and SQLSTATE, and I have found
that some of the errno definitions don't match to the manual.
For example, the manual says that ECPG_CONVERT_BOOL could be `-207'.
Ho
On 2010/09/12 23:02, adi hirschtein wrote:
I'm coming from the Oracle side of the house and In oracle for instance, you
use shared buffer as well, but you are still able to see which session is
waiting for which blocks
and if one session is doing the "real" I/O then the other one wait on 'wait
These three queries may help you to understand what's going on.
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog;
EXPLAIN ANALYZE SELECT count(catalog.id) FROM catalog WHERE flag=false;
EXPLAIN ANALYZE SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
Regards,
--
NAGAYASU Sat
Hi Louis,
2011/10/27 19:49, mailtolouis2020-postg...@yahoo.com wrote:
Hi,
I'm sorry I'm not good in C, anyone can help to put a patch or release a new
version for that?
Regards
Louis
--
2011/12/08 21:53, Tomas Vondra wrote:
- performance monitoring and diagnostics. It's way harder to find out
what's causing load on a busy Pg server or report on frequent/expensive
queries etc. Tooling is limited and fairly primitive. It's find, but
nowhere near as powerful and easy as some if the
2011/12/10 10:54, Greg Smith wrote:
On 12/08/2011 09:48 AM, Satoshi Nagayasu wrote:
For examples, I've been working on investigating PostgreSQL LWLock behaviors
precisely for a few weeks, and it could not be obtained within PostgreSQL
itself, therefore, I picked up SystemTap. However, Syst
21 matches
Mail list logo
