Re: Getting a better performance

Hi there!

INSERT INTO gorfs.nodes(node_full_path, object_type, permissions)
SELECT
pn.node_full_path, pn.object_type, pn.permissions
FROM
(
VALUES
(CAST(0 AS SMALLINT), CAST('/userfiles' AS gorfs.absolute_pathname),
CAST('S_IFDIR' AS gorfs.mode_t_constant_name), CAST('111111111' AS BIT(9))),
(1, '/userfiles/account', 'S_IFDIR', '111111111'),
(2, '/userfiles/account/2681', 'S_IFDIR', '111111111'),
(3, '/userfiles/account/2681/attachment', 'S_IFDIR', '111111111'),
(4, '/userfiles/account/2681/attachment/33168371', 'S_IFDIR', '111111111'),
(5, '/userfiles/account/2681/attachment/33168371/file', 'S_IFDIR',
'111111111'),
(6, '/userfiles/account/2681/attachment/33168371/file/7038561', 'S_IFDIR',
'111111111'),
(7,
'/userfiles/account/2681/attachment/33168371/file/7038561/main.with_name',
'S_IFDIR', '111111111')
) AS pn(elevation, node_full_path, object_type, permissions)
WHERE
(NOT EXISTS(SELECT 0 FROM gorfs.nodes AS en WHERE (pn.elevation < 7) AND
(en.node_full_path = pn.node_full_path) AND (en.object_type = 'S_IFDIR')))
ORDER BY
pn.elevation ASC
;

It took 8.120 ms...
Running an "api.php" from the website.

Thanks :)

2015-12-10 2:56 GMT+13:00 Kevin Grittner <kgrittn(at)gmail(dot)com>:

> On Tue, Dec 8, 2015 at 10:29 PM, Emily de Souza <emilysouzabg(at)gmail(dot)com>
> wrote:
>
> > I've got 3 DB servers, running PostgreSQL 9.2.14 with PHP APIs:
> >
> > 1 - Master DB (16 cores, 128 GB RAM, RAID 10)
> > 2 - Slave (warm standby DB - full sized)
> > 3 - Slave (warm standby DB - full sized)
> > 4 - Slave (warm standby DB)
> >
> > I would like to improve the performance, by slowing the response
> > time (ms) of the DB server.
> > But I don't know where to start.
> > Do you have some tips/how to about how can I get the information
> > that I need?
>
> Without more detail about your problem and what you're trying to
> achieve, it is hard to make a suggestion. If you can pick out a
> query that is taking longer than you expect, you might want to
> present that to the performance list, following the advice here:
>
> https://wiki.postgresql.org/wiki/SlowQueryQuestions
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>